Taking Buttons in Power BI Desktop to the Next Level

[@ThisIsFrederic]

I loved this "100-page" moment so much, thanks for this good laugh!

[@Геннадій-ц8э]

6:06 ))

[@nmbambo]

For me I think it might be viable only if the pages are group able into logical categories. That way, you can create the button and then add an action to it that opens a panel with subgroup items of various "pages" or "visual pagings" of your choosing. Choosing the item on the panel automatically collapses the panel and shows the page chosen. JustSayin'.

[@quinitawhitfield9541]

I love that the action of page navigation as an action on a button has replaced the need for a bookmark for each page.

[@MattyHD403]

I love how passionate you all are about this. It makes me happy :)

[@GuyInACube]

Thanks for the kind words and thanks for watching! 👊

[@janibashashaik9412]

@@GuyInACube Hello, it's greate video.can i get that pbix file to see and get more exposure on this plzzzzzzzzz...its really [e-mail]...

[@CCHSmathematics]

I use buttons often but have not layered a button on a card. I love the idea and already know of a few ways this will help save real estate.

[@nsgoldchannel]

This is really REALLY helpful and will change my approach. I'd gone down this route but had reservations as I didn't appreciate the significance of turning off Data, Display etc and couldn't figure out why clicking my buttons erased prior filter choices. Switching off Data in my bookmarks was the eureka moment you gave me to fix this. Thanks so much!!

[@GuyInACube]

YES! 👊 These can be very powerful. Glad it helped you on your journey.

[@sqldevdba9719]

Thanks so much for this video! We watch Amanda's videos every month and always wonder how the buttons look so awesome. The blank buttons on top of card just blew my mind! Thank you!

[@officesuperhero9611]

Great video. I recently learned about UNCHECKING the data option for bookmarks. I think those items should be UNCHECKED by default. Also, I have created buttons by creating images, grouping them together and then placing invisible/clear buttons over them. Would love to share with you what i did with buttons. I have gotten some really good feedback from people.

[@sushmita4713]

Please share it with me. I would like to see what you did

[@ayushmannanda5394]

Even I need to know

[@thesatwikshenoy]

Thanks a lot for this. I always used a transparent rectangle shape. Not sure if a blank button and that is the same. But this sure changes the way I use buttons now!

[@GuyInACube]

Similar concept. 👊

[@AmandaCofsky]

The nice advantage of the buttons over rectangle shapes is that you can add the fancy hover effects. But if you don't need that, shapes definitely work as well!

[@thesatwikshenoy]

@@AmandaCofsky thanks a lot! Can't wait to try this out for my upcoming projects! Looking forward to more content just like this one. Cheers!

[@diogopinto6039]

Very useful and beautiful design! As for the question, sometimes when I need more realstate I like to create slicers that actually select what measure is being shown in the analysis.

[@rjcassiafn]

You're making me actually like Power BI. The UX Team designed a tabs view and I was a bit lost on how to implement it using Power BI but you shed some light on the matter. Thanks.

[@GuyInACube]

Love it! I'm gonna get Chris Hamill on one of our live streams to talk more about report design.

[@RenatoHaddadMVP]

Great video about Buttons, thanks. I would like suggest your team thinking about create a navigation panel, like a frame in web apps. you can add / remove or change any buttons in this frame. And also set the navigation panel on top or left.

[@manrique547]

Agreed, that would be great!

[@paulrodriguezrevilla329]

Amanda ... very useful ... i go almost 2 weeks viewing all the material ... thank you for posting ...

[@Sanj803]

Good to see Amanda here with Adam, religiously listening to updates every month and eagerly waiting every month. You are doing great job. Please give user some control over data label positioning.

[@jurakovtun6763]

You guys are just amazing! Still watching this in 2022 ;)

[@rkandathil]

It'd be great to have a button manager, so you can group them just like you can group bookmarks!

[@godude6950]

Similar to the new cross report drill through feature. I would love for these buttons to be able to navigate to pages in other reports all while staying within the same . I understand the link to a web URL is possible but being able to keep it in the same would be key

[@samjosoff]

Is there a how-to on how to create the rest of this beautifully professional report? It was great to understand how the buttons work. I would like to see how the "next level" Report layout is designed

[@Jolaracu]

I am doing exactly the same as Amanda did with page navigation using buttons, moreover, my client asked me to create an interactive menu that changes from one visual to the other (same product but different measures) so, I am about to get into that visual layering using the selection panel. I had that idea and after this video, I am sure I was pointing in the right direction. Thank you very much Guys.

[@musafirq]

Awesome use of buttons...Thanks Amanda

[@GuyInACube]

Thanks for watching! 👊

[@varshaks7401]

I have done so many cool stuff in my reports after subscribing to your channel. Thanx much

[@mwaltercpa]

Loved seeing this on the Covid dashboard on the live call this morning. This was helpful :)

[@GuyInACube]

awesome! Yeah you can do some crazy stuff with buttons and bookmarks.

[@BritonWells]

Would love toggle switches - currently able to do this with 2 overlapped images right now. Use case to give users options to swap visuals (e.g. cumulative vs periodic)

[@cybertrophic]

Briton Wells and a customisable radio button selector.

[@anirudhacs8814]

Yes please! I was searching for toggle switches too before I landed on this video

[@hi_vishy]

Excellent. I would definitely use it. It would be a good idea if pbi allows to hide tab names at the bottom like Excel; this would make those buttons more meaningful by forcing user to use them. Also, would request you to create a detailed video on all the options of bookmarks. There is none that explains it well.

[@jaapolsthoorn796]

It already does! You can choose to hide tabs so that when you put the report online, the users won't see them, but you won't be prevented from navigating to them :)

[@pgcsec]

Great to see this in action - and now means I can add it to my work - thank you

[@GuyInACube]

You are welcome!

[@maxartman8277]

Great video. I'm just starting PowerBI and it is exciting to see all of the things it can do.

[@kealkil4]

Liked the video. Not being able to set a Default Slicer value, is the issue that causes me most grief with Bookmarked Reports.

[@akshaybholee3263]

now we have the new perfect feature for button, Page navigation. No need to use bookmark to navigate to pages. The buttons can be used for cool slicers now or drill down effects. i wanted to point out also if it's possible to remove the page navigation arrow below the report after publishing it so as to make the report more like an app feel.

[@hjk01031967]

I plan on playing around with this, crazy good stuff

[@leyshonrr]

Fab video, good to have an explanation for the data, display and current page checkbox options. I'd love to be able to group my selection pane items together in the same fashion as bookmarks, then be able to show or hide whole groups of objects, such as my collapsible slicer selection panes. Really like the blank button overlay on cards too.

[@johnfromireland7551]

There is now a Page Navigation option rendering the intermediate bookmark steps as not required.

[@David-ey2jf]

I use buttons and bookmarks all the time but the invisible buttons over other content idea was new to me. I started using it today in a new report I'm building. Thanks for the tip!

[@michellejamison6263]

That navigation is awesome! This video has great info and tips. Thx.

[@galellopez4214]

Great video, It's an Excellent support. I would like to request, if Microsoft Power Bi can include more icons for the buttons options. Thanks for this video, really help me a lot.

[@LizBethA63]

Or the ability to add your own icons (just let us know the size and info .. we have a lot of icons in our industry that mean different things and having this ability would be a great capability! - idea time)

[@angus6095]

@@LizBethA63 You can do this by inserting an image and then setting its properties to the bookmark.

[@2404Pepe]

Great girl !!!! she is simple and knows her stuff. Thanks so much

[@anirudhacs8814]

This channel is awesome! I've watched about 20 of your videos and I love the passion with which you talk. It is not a regular boring tutorial video that is hard to follow. When I'm watching your videos, I'm focussed 100%. Thank you so much! It's helping me a lot in my work

[@MarkDarbyshireyepitsme]

if you're going to use this method of layering visuals on top of one another, group the visuals in a sensible order. for instance, say you have a P1 button that is 'disabled' if you are on page 1, and another P1 button that is 'enabled' if you are on another page, and they are layered on top of each other, making one visible and the other hidden depending on the bookmark chosen. take both of those buttons and group them (by selecting both button in the Selection pane, click on the ellipses, and choose Group) and name the group something logical, like P1 buttons for this example. by grouping the buttons, they become a cohesive single unit. by doing this, you can make them both visible/hidden in the selection pane, but more importantly, they move as a unit. so, if you are redoing the layout of the page, you drag and drop the Grouped buttons instead of each one separately.

[@sanchit-sood]

Good to see you Amanda... Last time I saw you, was in the Introduction video to Power BI. I follow your Power BI updates video. The way you present is amazing , really easy to understand . Thanks Adam for bringing her. :) Keep up the good work Guy's. Lot of us here follow you.

[@gauravmore5987]

Really like the concept! I have been using plane images for bookmarks purpose but this sure seems promising.

[@GuyInACube]

Woot! Glad this was useful. 👊

[@channeltorontovlogs6993]

I am very excited to see the wat of discussion, lot of love for you both

[@TheVamos777]

Like the invisible button trick. Also the selection rename is great, wish it was around when I build a 19 page report with load of visuals

[@paulskuse3209]

Would love to see a selected state for a button too. We're often building two sets of buttons so that if something is conditionally selected, the button changes colour (i.e. switches to another button!). It would be great if we could just use one button for this!

[@daveflood5176]

Thanks so much! Such a great channel...every video I watch, I learn something valuable!!!

[@GuyInACube]

Great to hear! Thanks for watching Dave 👊

[@mohanrajs871]

Thank you for the video. Really useful with the page navigation as I am embedding the report in the application where vertical scroll makes no visibility to the tab pages below.

[@milindsoman1982]

Would love to see button as symbol (in terms of Flash :P) so that a colour change in one place would reflect all buttons across pages, a big time saver!! Thanks for the video.

[@GuyInACube]

Great feedback! Appreciate that.

[@angelaebirim2705]

Very nice. Let's have more!

[@vog5197]

I started removing titles of objects in the View pane, because when a report is loading in the service, it shows the titles for a split second even when you have turned the titles off. I find it lifting the veil when the viewer is seeing a white page load with just a bunch of titles and loading circles at the start.

[@israelgonzalez677]

Awesome! I am just beginning with Power BI and your videos are quite useful :)

[@mehdihammadi6145]

Thank you both

[@shivendrakumaryadav5811]

Thank you so much for sharing this. It helped. Additionally, I have used "Sync Slicers" to carry forward the filtration.

[@attitudecatalonia4300]

I do something similar but using a slicer who select the different measures on the charts, for example changing from Quantity to Value

[@GuyInACube]

I've seen that approach before as well. Definitely useful. If you want to do more than that, the button/bookmark approach may be a better option. Especially if you want to change the visual type as well.

[@hi_vishy]

@@GuyInACube but if we use bookmarks instead of slicers to display different visuals based on selection, it would impact the performance as there would be two visuals that would be refreshed.

[@RobertJuly-so2ni]

Great. Thank you. It helps me alot.

[@awatsky]

I'm actually using the hidden button technique but instead of having multiple pages I have one page that has a ton of different views depending on what I click on.

[@terrapinryepaleale]

Another AWESOME video tutorial! Glad I'm watching these before we get too deep into our initial Power BI rollout so we can incorporate all the (reasonable) functionality now.

[@MarkCBB86]

It would be great if we were able to load simple code steps instead of the manual setup, example on click event, navigate("pageName"); Shape("chart1").visible = true and then assign those events to buttons

[@prasadk5082]

Absolutely.... great ideas.,.

[@baluaadyaanju]

So we can create a dashboard kind of thing in power bi desktop as in power service,but it is actually a report.... Very nice...i learnt good stuff to day...thanks

[@GuyInACube]

From my experience, a lot of folks use a report as a dashboard. Definitely possible. 👊

[@celuikivient]

This is awesome ! I am defintely going to use it !

[@andydougy4347]

Cheers sons crying...from happiness. This was great planning on diving into a new report using the buttons over cards.

[@sforti01]

Excellent video. I laughed at the calculating dramatic pause at 6:07!

[@joaquinrocha5433]

its great to show the real power of the buttons, one question. How do you generate a bookmark to hide the diferent visualizations?

[@itpatel7268]

Excellent video, thanks a bunch to both of you for sharing these OOTB skills.

[@manuel_antonio_rivera_socarras]

awesome features!!!

[@davidpanza4385]

This is great! I have created my navigation menu using pictures, directing bookmarks to each one, instead of using buttons...

[@GuyInACube]

Awesome! Very exciting. Glad you were able to get that sorted. Thanks for watching 👊

[@tommartens3953]

Once again an awesome video, and of course a great guest. Since the April release, I use the title property as it is possible to create dynamic titles - thanks for this feature. Maybe you might consider creating a "toggle" effect, meaning hitting the button the 2nd time goes back to the previous state.

[@Soulenergy31]

4:50 this part is key!!! thank you Guys in a Cube!!!!!!!!!!!!!! Love it!!

[@guusvanzuylen6501]

Awesome examples! Can you please share that 2nd .pbix too? I love your solution of blank buttons layered over cards.

[@kapilkumarasamy5059]

thank you so much... was looking for something that you explained at 4:55 . It helped a lot..

[@abidaabida1624]

honestly power bi is the greatest thing i have ever used. i used to be a weak bi but with power bi helping me out, i am now a certified power bi. even since using this my bisexuality has gone up in great lengths and now i am more confident in myself. im even thinking of coming out of the closet. so thank you power bi for helping me gain more confidence in my bisexuality and basically powering up my bi. - with great love a certified power bi

[@Candy-o3t]

Option to group bookmarks is great, clears things up. What I think could be improved to have this same hierarchy automatically under actions-->bookmark dropdown selection, where you have to assign the action to the button. Otherwise it can be quite chaotic there after a while

[@yeasinarafatredoy9665]

Can you please share the PBIX file with us. That will so much helpful for us. :)

[@christiancarrascoFut]

I got it here. github.com/microsoft/powerbi-desktop-samples/blob/master/2019/2019SU09%20Blog%20Demo%20-%20September.pbix

[@JEffigy]

Can you share it again please? Love this report

[@sjames1958]

Great video. One thing to feed back is embed codes can be hard to manage, it would be great if we could have a 'friendly' url instead of having to point at a report via an embed code. That way if a report needs to change our external users don't need to worry if the embed code changes. Thanks

[@femisape]

If you have 2 buttons, how do you change the color of the other button when you select the other button and vice versa in the same page?

[@ashwinshankar]

Thanks Guys, this is awesome. My question is If I have 2 separate sets of buttons using bookmarks to toggle between table and chart. How do I make the bookmarks not impact the other bookmark selection

[@EricaDyson]

Excellent. Thanks so much. Keep them coming! We need your insights and know-how!

[@kingabullert7037]

This is very helpful, thank you. There is one functionality that I wish was easier in Power BI. That is enabling and disabling buttons based on the selection in visuals. For example, can I have a button that is grayed out unless I make a selection in my graph? I know there is a drill through button option with the March update, but there is no way to style the button while it's disabled - that is a major drawback of that feature.

[@mikkelmortensen3964]

Buttons are great for navigating in reports :-) , but they could be even better if we could use them to switch between different values from a column like for example months when using a BciCalendar visual or static tables showing forecast accuracies for a single month, then click a Prev/Next button to show the previous or next month's summary, so we don't have to paste 12 visuals on top of each with bookmarks.

[@Rewena789]

Great video and I have a question. When you are showing the blank button on top of a card, is that a multi-row card with different colors I'm looking at (Usage)? I didn't think that was possible. I must be missing something. Thanks :)

[@christofferlokrheim645]

I'm now using a button to toggle on or off advanced Tooltips. I've so far only figured out a way to do it by having one report page with native tooltips, and another duplicate where custom tooltips is added to each visual. Would have been cool to be able to save a visual property setting in the bookmark it self rather than switching to another report page :-)

[@hasnainhaider8191]

Oh my, this was helpful. My first step in beautifying my dashboards :)

[@NaraMeerammaTrust]

Very useful Video and excellent presentation. I really liked it. Where can i find your Monthly videos on Power BI Amanda Cofsky? Please send me the link if possible. Thank you

[@GuyInACube]

The monthly videos are part of the regular monthly Power BI Desktop release blog posts. Here is the post for April 2019 - powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/. The videos are hosted on the Power BI KZbin Channel - kzbin.info

[@ChandooD]

Awesome ideas Amanda.

[@ziyad4u]

Great video! This is really helpful for pbi devs to improve the user experience.

[@nandyy27]

hi, Thanks a lot for all the tutorials. Its great, please keep doing such videos. Can anyone tell me if they have created a button which can be used to export visual data (table) to csv or xl?

[@abufaisalkhajapur2705]

There is a 'Page Navigation' action under buttons so now you don't have to create a bookmark for each page in your report.

[@RobBastien]

Great stuff. I'd also like to see graphicaly pleasing U.I. landing pages, including company name, logo and tiles linking to dashboard pages.

[@Kmsbi]

Great video. I make beautiful Navigation menu after watching this video thanks.

[@rollyvincoy3848]

How about allowing the buttons to be synchronized across pages just like the slicers? We have a report that has two synchronized slicers, campus and organization, that only one is really used at any given time (actually, in the infomart, if there is a selection in the campus, then that is the filter that is used, otherwise the organization slicer selection is used). It is easy to use bookmarks and two buttons to unselect the campus slicer and hide it and show the organization slicer and show the other button for switching views. The lack of synchronization problem comes in because we have like 9 pages on that report and you cannot control what button and slicers to show on the other 8 pages that matches the current page.

[@smallflyDE]

Inspiring video! Thank you! I will try that :-)

[@PTimbs]

Very helpful

[@michaelparsons9235]

This is great!!

[@Amr-Ibrahim-AI]

Nice to finally see you Amanda 🙂

[@malla1990]

Great stuff! Is there a way to navigate to different pages without pressing the control button first?

[@faroma80]

Great tip!! Is there any way to click the button without need to keep CTRL pressed?

[@phanisai9241]

Hello, Can you teach us ...when we hover on the button (P2) it should zoom out reveling the P3 like the animation on the Ring chart by MAQ software...it will make the report more visualizing

[@PSAndPowerBI]

very good perfect topic

[@will1315]

Thank you so much for showing this! Very good method to improve UX

[@taochen746]

Very useful, thanks

[@GuyInACube]

Thanks for that Tao! Glad it helped 👊

[@ajitkancherla9594]

Appreciated for all your knowledge Hub!! will that be possible for video on Hide/show radio button using DAX measure and filed Value

[@marlalash9762]

I'm a new member. I have a dashboard with multiple slicers. I would like to be able to click a button to reset all the slicers at once. Maybe a button isn't the way to go, but this video makes me think it is.

[@GuyInACube]

Appreciate you becoming a member! 👊 If you have a bookmark with the default state, it should work. You would need to validate that the selections for the bookmark include the right states (i.e. data, etc...) I usually have to try a few different combinations to verify it is working.

[@willbee6591]

This is all really great! But, is there a way to execute the action in a button WITHOUT needing to hold down CTRL?

[@GuyInACube]

Within Power BI Desktop, when authoring, you need to hold down CTRL. Once it is published in the service, when consuming the report, you don't need to hold down CTRL.