Swap Power BI Visuals to add FLEXIBILITY in your reports
Вставка
- Опубліковано 31 бер 2021
- Want to avoid visual clutter in you Power BI reports? Here's a technique you can apply to swap out items to allow for more exploration of your data and give your consumers options.
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #Visuals #GuyInACube - Наука та технологія
Great video! I've been using this technique for awhile now and I've found it's helpful to group your visuals to easily identify them when creating bookmarks. Simply select your visuals from the selection pane and right click them, select group and give it a name. I see that you did the same thing with "slicer panel" but it might be worth mentioning this technique.
I've used that in a report to improve performance and change the aggregation of the data by different dimensions instead of having a cartesian product dimension.
Result: it was 10 TIMES fastest.
Great video, Adam, as always
Incredible- definitely blew my mind! No more creating huge pages that are hard and non-intuitive to navigate. Thanks so much
Really great to know about all selected! Thanx Adam
Fantastic Adam, thank you for the walk through! I used a similar technique in Tableau, but this seems easier 🤠
Short and sweet explanation. Love it!
Great timing Adam, I am going to use this solution today! Please keep up the great work!
Awesome as usual GIAC team ! You rock
LOVE layering pages, reduces overall page size while proviising maximum info
Yes, yes, yes! Very useful. Thank you. I'm using bookmarks to update filtering for different customer audiences. This swapping is just the thing I need. I want understanding selected visuals option on the bookmark properly.
Personalise visuals in the service also achieves this really well too. Such a good way to customise multplie visuals to the users needs
Just discovered this channel, and these guys are my favorite now :)
Just used this technique in a project. Thank you for sharing!
BAM! Great to hear!
Doing it already but haven't used selected visual option. Thankyou for sharing
If you only do 1 swap button you can do it without that option, but as soon as you add more buttons and navigation options you'll have to use selected visuals to avoid constantly refreshing the page
Thank you so much for this video.. Got struck in the same concept without knowing that we should add all the hided visuals in the bookmarks as well to get the correct visual when we select the toggle button.
Had to do a really complicated report with the help of bookmarks, selections and data. Its nice to see how "Selected Visuals" is used
I love UA-cam suggestions sometimes. I was wondering if Power Bi could do something like this yesterday as I didn't want to have to create a bunch of pages. This video was suggested by UA-cam and was exactly what I needed. Thanks for the great video, Adam!
ya this i have been using except the selected visuals part, again an awesome video and really valuable
Love love this, took me ages to understand these before, this would have been so valuable then but also really useful as best case practice for the workflow in setting them up. #masterbookmarks, more please! Making the reports easier to navigate is critical.
Same as you - mind blown! Great tip Adam - thanks for sharing it!
I do this all the time ever since you showed how to set up buttons with bookmarks...it makes my reports so much more customizable and clean at the same time.
@@dylanvalencia349 yes. You would need 2 different graphs, stack them on top of each other and you would hide one in one visual
Great video! Probably grouping the objects which are being hidden/shown would make the bookmark setting even more streamline, at least that is how I usually manage my bookmarks and objects.
This is a great utility! Thanks for sharing!!
Great video.. I did not even think about switchingvisuals..Thanks so much..
Been using this for a while but as others said it can be high maintenance. Would be nice if such functionalities came out of the box. Perhaps a virtual container box that let's you add multiple visuals to a container and switch between them easily. In addition to your video I would advice to group the selection layers btw, this allows for easier editing.
You gave amazing insights and pro expertise to apply in our reports.
Awesome! Super-friggin-cool. Solved a problem I've been grappling with for a few weeks now! Thanks so much.
Thank you for this video finally I have done this
Awesome! Exactly what I was looking for.
Beautiful! Thanks so much, this just saved my final page of my project. Kudos!
Great video. Somewhat comforting, I've already done this to show/hide charts. Yay.
I didn't even know I needed this so much LOL.
Thanks so much!!!
Wonderful content. Thanks for that!
This is great , I am definitely using it.
This is amazing! Thank you!
Very useful, i have used this trick but Selected Visual is new for me. As always thanks for sharing :)
Thank you! I just used it!! :D❤
You guys are amazing!
I was trying to have 2 of these toggles on my report and thats when I realized when the All Visuals breaks things. I knew selected visuals was the answer but I couldnt figure it out... Going to try following this step by step, thanks!
Excelente vídeo, muchas gracias por toda la información que brindan.
Powerful presentation Adam
While I've been using bookmarks in testing, I haven't really rolled it out live yet, I've only really unticked the data option so I'd love it if you done a video on all the bookmark functionality. The selected visuals is a game changer, I can't believe I haven't used it... Definitely #masterbookmarks
Thanks for sharing, slowly coming together...
Great tip. Can't wait to use this.
Thanks for the great video.
This was so great.. such a great fix with such simple explanation!!! Thanks a lot..:):)
Great insight.Gonna try out.
found the solution right away thanks for this!
Thanks. It helps a lot
Thanks a lot Adam . This video was really helpful . Just wanted to clear my understanding of the bookmarks..
can we please have a video in the future explaining ‘data’ ‘display ‘ ‘ Current page ‘ feature ? What happens if we keep data - uncheck display or vice versa ?
Just what I needed
This is really baller. Thank you!
I use book marks often. I did not know you could do just a few visuals instead of the whole page. That was a nice trick to know. My pet peeve is when I have a book mark just the way I want it, then I add a visual somewhere else and it messes up my bookmark by showing up. I'm hoping this fixes that problem as well.
Thank you !
Awesome insight!
#masterbookmarks I actually started doing this exact thing just a few months... created: Navigation Menu, Menu Tree, Filter Display toggles, Visual toggles (Charts vs Matrix) and Quick Granularity buttons... word of advice, use groups and naming conventions that make it easier to locate when linking to an Action... Selections multi-layered groups, Bookmarks only single layered so can get messy
Are all bookmark calculated at the same time (when user opens the report) or it only calculates when you select the bookmark ? Thank you , awesome video .
Exactly what I needed 🥰
BAM!
what a tip that I am using in my report have those arrows inside the visualizations. thanks
Thank you so much
great work
You're the only Power BI channel that doesn't add to my new pet peeve - Power BI videos.
Thank you
Hi Adam, you're doing great job. This video inspire me a lot to play around Power BI. Just one quick question!.. . how to change the visual position using bookmark? plz suggest some tips, it would be very helpful for my report.
Thanks for sharing your knowledge in best way!...
great video, can this be done for all graphs within the page?
great video, we would like to know if there could be a video to show us a matrix table and using a slicer to choose one or more measures to be included in columns, please, thank you.
Thanks buddy. exactly what i was looking for. May God Bless You! Jai Shri Ram!!
that is amazing!!
Great Stuff
Blew my mind!
Please can you do a video on how to add a scroll bar to the whole page to add more visuals. Thanks!
#masterbookmarks - yes please add more content like this - I've never played too much with bookmarks because it seems tedious and complex - resulting on adding an extra page for a visual that I could have included like you did on the video. thanks!
Thanks for the intro to Bookmarks & Buttons. #MasterBookmarks
Sorry if this is a silly question: In the video there is a transition effect between the bookmarks. The angled line with the circle in the middle that slides across to show the new visual. Is this transition effect doable in Power BI? Or was this added to the video in post-production for emphasis?
Amazing 🤩
great video! but how did you got the animation for the intro part going? is that something specific for the video only? or can it be done within powerbi?
Very good. I finally realized what the 'Visuals' option is for. #masterbookmarks
#masterbookmarks ...yes would like to understand what we can and (equally important) what we cannot when setting up a bookmark. Bookmarks are very powerful but still high maintenance if the report needs changes. Thanks Patrick
Great video, as usual. Yes, #MasterBookmarks
What exactly the difference is all visuals and selected visuals. I didn't get it.
But as always great video... really helpful.
Guys you are Awesome Really !!!!!!!!!!!!!!!! I wanted to know Is there is way to create an alert or notification for data contain (Past dates and further dates) alert for further dates of 2 months prior is there is way????
I am already doing most of this but never played around with Selected Visuals. I prefer to group together the 2 sets (tree/button and waterfall/matrix/button)
Great Video, but how can I obtain the same effect of showed in the first seconds of this video ? I explain myself, wht 2 buttons you can switch from one visual (or group of visuals) to another...but in a static way. In your video you show us that you use something like window handle to swith from one visual to another one. How can I obtain tihs effect ? thank for you reply.
Great Video! Can't wait to use this in my current reports or new reports. #masterbookmarks
Hi Adam Saxton
💊 Selected visuals in Bookmarks is like the red pill in Matrix 😎 #MasterBookmarks
👨🏫 I teach that in my Power BI courses
Thanks for sharing
I needed this!!! #MasterBookmarks
I luv you guys
How to switch the visuals based on slicer selection and all instead of button? Any workaround pls
#masterbookmarks - I've never really had a satisfactory explanation of 'selected visuals', so this would be useful.
great video - but i really enjoyed the matrix funny stint of 2 sec
Thanks Adam it is a great video #masterBookmarks
Excelente
#masterbookmarks
Thanks Adam (and Patrick). Amazing video as always.
Can I ask you if there is any way to identify which visuals have been selected when the bookmark was created if you look at this afterwards?
I have seen this beforein other reports already created by someone else but cannot see a way to identify the visuals selected at the time of creating the bookmark.
Thanks
#masterbookmarks - I usually use bookmarks to add panel with additional slicers, expand multiple line cards through some dimention or show table prepared to export.
I have used this concept a lot in my projects... Can you get me some trick, on how can we switch visuals based on a measure value...
Like a measure is a switch DAX statement... Based on that value we can show different visuals...
Kindly share if you have any such trick.
Yoooo. Awesome videos. Do you know any way to auto grab a users Microsoft profile photo and display in a report? Thanks for the videooooos.
Can i download this file? if so from where? Appreciate if you can let me know. Thank U
Love to see some more Power BI mind blowing skills - #MasterBookmarks
#masterbookmarks I’ve set up various bookmarks but largely kept the settings of the bookmarks settings as is. I’ve tried playing around with the different settings but either created issues or didn’t see what I expected. Additional content here would be awesome!
#masterbookmarks another awesome lesson from the PBI OG himself! Thx!