Taking Buttons in Power BI Desktop to the Next Level
Вставка
- Опубліковано 30 чер 2024
- Amanda Cofsky joins us to show how you can use buttons, in Power BI Desktop, to take your reports to the next level. Blank buttons can really make your Power BI Reports shine.
Connect with Amanda on Twitter: / missamandan
********
LET'S CONNECT!
********
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
Check out my Tools page - guyinacube.com/tools/
#PowerBI #PowerBIDesktop #GuyInACube - Наука та технологія
I loved this "100-page" moment so much, thanks for this good laugh!
6:06 ))
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'.
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!
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.
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
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.
Thank you so much for sharing this. It helped. Additionally, I have used "Sync Slicers" to carry forward the filtration.
I love how passionate you all are about this. It makes me happy :)
Thanks for the kind words and thanks for watching! 👊
@@GuyInACube Hello, it's greate video.can i get that pbix file to see and get more exposure on this plzzzzzzzzz...its really helpful...khwajaameen0786@gmail.com...
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.
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!!
YES! 👊 These can be very powerful. Glad it helped you on your journey.
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.
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.
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.
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.
Excellent video, thanks a bunch to both of you for sharing these OOTB skills.
Great video. I'm just starting PowerBI and it is exciting to see all of the things it can do.
Excellent. Thanks so much. Keep them coming! We need your insights and know-how!
Thanks so much! Such a great channel...every video I watch, I learn something valuable!!!
Great to hear! Thanks for watching Dave 👊
Amanda ... very useful ... i go almost 2 weeks viewing all the material ... thank you for posting ...
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.
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.
Love it! I'm gonna get Chris Hamill on one of our live streams to talk more about report design.
Great to see this in action - and now means I can add it to my work - thank you
You are welcome!
Loved seeing this on the Covid dashboard on the live call this morning. This was helpful :)
awesome! Yeah you can do some crazy stuff with buttons and bookmarks.
I love that the action of page navigation as an action on a button has replaced the need for a bookmark for each page.
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!
Awesome! I am just beginning with Power BI and your videos are quite useful :)
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
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.
That navigation is awesome! This video has great info and tips. Thx.
I have done so many cool stuff in my reports after subscribing to your channel. Thanx much
Really like the concept! I have been using plane images for bookmarks purpose but this sure seems promising.
Woot! Glad this was useful. 👊
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
It'd be great to have a button manager, so you can group them just like you can group bookmarks!
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!
Similar concept. 👊
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!
@@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!
Thank you so much for showing this! Very good method to improve UX
Very useful guys. Your videos have helped me a lot. Keep doing it like that. Thank you :)
Love it! Thanks for watching. 👊
You guys are just amazing! Still watching this in 2022 ;)
Sending some love to Amanda! I recognized your voice right away from the Power Bi Update Blog !
thank you so much... was looking for something that you explained at 4:55 . It helped a lot..
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
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.
Please share it with me. I would like to see what you did
Even I need to know
This is awesome ! I am defintely going to use it !
If you love this Report layout, Come on over to PowerBI.Tips and download the Report here: powerbi.tips/product/layouts-microsoft-sept-2018/
Cheers sons crying...from happiness. This was great planning on diving into a new report using the buttons over cards.
Oh my, this was helpful. My first step in beautifying my dashboards :)
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.
Agreed, that would be great!
I plan on playing around with this, crazy good stuff
Great girl !!!! she is simple and knows her stuff. Thanks so much
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
This is great! I have created my navigation menu using pictures, directing bookmarks to each one, instead of using buttons...
Awesome! Very exciting. Glad you were able to get that sorted. Thanks for watching 👊
Thank you so much for the great tips!
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
From my experience, a lot of folks use a report as a dashboard. Definitely possible. 👊
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
Excellent video. I laughed at the calculating dramatic pause at 6:07!
Best video, Keep up the great work!!!
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!
Awesome use of buttons...Thanks Amanda
Thanks for watching! 👊
Great video! This is really helpful for pbi devs to improve the user experience.
Very very useful... I was wondering how I was gonna do some interaction effects, now I wonder no more ;) Thanks!
Thank you both
4:50 this part is key!!! thank you Guys in a Cube!!!!!!!!!!!!!! Love it!!
Absolutely love buttons and use it all the time! @Amanda i know the template is available for download too and im sure more folks would love to get the link to it :D unfortunately i downloaded it but no longer remember where from :(!
Also a really awesome way to use the buttons is to shift between visuals for example you can show a pie chart and the data table of that pie chart using buttons which is amazingly powerful for high level + detailed information
AMANDA! So cool to put a face to the voice! Love your videos every month! :D
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.
Inspiring video! Thank you! I will try that :-)
Awesome ideas Amanda.
Very help full video ,thanks a lot for this one information
Liked the video. Not being able to set a Default Slicer value, is the issue that causes me most grief with Bookmarked Reports.
Perfect video! Informative, quality and fun! More videos like this please! I have some feedback
Easier way to create and manage these interaction, such as allowing users to manipulate the underlying JSON file for reusing, bulk creation and edition, and so on. Even better, we can share those metadata with others! It would open up the Power BI ecosystem even more!
Great video, thank you!
I am very excited to see the wat of discussion, lot of love for you both
Nice to finally see you Amanda 🙂
awesome features!!!
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.
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 :)
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.
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.
Great feedback! Appreciate that.
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.
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)
@@LizBethA63 You can do this by inserting an image and then setting its properties to the bookmark.
This is great, thanks!
Awesome examples!
Can you please share that 2nd .pbix too?
I love your solution of blank buttons layered over cards.
Great. Thank you. It helps me alot.
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
Great stuff. I'd also like to see graphicaly pleasing U.I. landing pages, including company name, logo and tiles linking to dashboard pages.
Great Tips, Thank You
Most welcome! Thanks for watching. 👊
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.
Great video. I make beautiful Navigation menu after watching this video thanks.
Thanks for greate info.. but here I have one question
Do we need to add the navigation buttons in each page?
Very nice. Let's have more!
Hey! Good tricks, as always, congrats, this time, to MissAmandaN! . Thanks!, I'will follow her in twitter.
Thanks, again
gab
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?
This is great!!
Love the blank button idea. I’m going to layer it into a customer issue tracker. Question for y’all, do certain data sources load faster than others? I’ve been using Excel but is Access or SQL quicker? I’m looking to improve load speeds. My datasets aren’t even that big, sub 1000 rows
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 :)
Great stuff! Is there a way to navigate to different pages without pressing the control button first?
Great Video! Thanx a Lot!
its great to show the real power of the buttons, one question. How do you generate a bookmark to hide the diferent visualizations?
Great. In bookmark usage like you, when i have a lot bookmarks, it is unlike to have all of them in the action pane. When Microsoft will add the group level on the action button ?
Hi and thank for both of you for a nice and informative presentation. Just one question; after making these new buttons with their connection to bookmarks, is it possible to adapt these funktionalities in the final dashboard as a view person? Greetings, Pasi from Finland
Absolutely.... great ideas.,.
Awesome video!!! Thanks
Appreciate that! Thanks for watching. 👊
Thanks! What about using slicers instead of buttons to achieve the same thing that you showed with the cards? Is there a way to use a dropdown slicer to change the visuals on the page?
I do something similar but using a slicer who select the different measures on the charts, for example changing from Quantity to Value
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.
@@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.