Swap Power BI Visuals to add FLEXIBILITY in your reports

Ғылым және технология

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

Пікірлер: 201

  • @timgray7859
    @timgray78593 жыл бұрын

    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.

  • @gulhermepereira249
    @gulhermepereira2493 жыл бұрын

    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

  • @nawaazr5388
    @nawaazr53882 жыл бұрын

    Incredible- definitely blew my mind! No more creating huge pages that are hard and non-intuitive to navigate. Thanks so much

  • @arnohoedelmans
    @arnohoedelmans3 жыл бұрын

    Really great to know about all selected! Thanx Adam

  • @shamf6624
    @shamf66243 жыл бұрын

    Doing it already but haven't used selected visual option. Thankyou for sharing

  • @ITyraxI

    @ITyraxI

    3 жыл бұрын

    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

  • @michauJi
    @michauJi2 жыл бұрын

    Short and sweet explanation. Love it!

  • @KLMCats
    @KLMCats3 жыл бұрын

    LOVE layering pages, reduces overall page size while proviising maximum info

  • @georgevandyke7486
    @georgevandyke74862 ай бұрын

    Fantastic Adam, thank you for the walk through! I used a similar technique in Tableau, but this seems easier 🤠

  • @topher60657
    @topher606573 жыл бұрын

    Great timing Adam, I am going to use this solution today! Please keep up the great work!

  • @driouchemountasir7894
    @driouchemountasir78943 жыл бұрын

    Awesome as usual GIAC team ! You rock

  • @DarkOri3nt
    @DarkOri3nt3 жыл бұрын

    Personalise visuals in the service also achieves this really well too. Such a good way to customise multplie visuals to the users needs

  • @crackerzin-bi6746
    @crackerzin-bi67463 жыл бұрын

    Same as you - mind blown! Great tip Adam - thanks for sharing it!

  • @beyondtriggered4145
    @beyondtriggered41453 жыл бұрын

    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.

  • @beyondtriggered4145

    @beyondtriggered4145

    3 жыл бұрын

    @@dylanvalencia349 yes. You would need 2 different graphs, stack them on top of each other and you would hide one in one visual

  • @drathman_DX
    @drathman_DX5 ай бұрын

    Just used this technique in a project. Thank you for sharing!

  • @GuyInACube

    @GuyInACube

    5 ай бұрын

    BAM! Great to hear!

  • @TheMrWARLORD
    @TheMrWARLORD2 жыл бұрын

    Just discovered this channel, and these guys are my favorite now :)

  • @harinisivakumar4500
    @harinisivakumar45002 жыл бұрын

    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.

  • @brad7648
    @brad76482 жыл бұрын

    I love KZread 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 KZread and was exactly what I needed. Thanks for the great video, Adam!

  • @WendyK2222
    @WendyK2222 Жыл бұрын

    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.

  • @allthingspowerbiwithadebol3576
    @allthingspowerbiwithadebol35763 жыл бұрын

    Had to do a really complicated report with the help of bookmarks, selections and data. Its nice to see how "Selected Visuals" is used

  • @seshadriraj
    @seshadriraj3 жыл бұрын

    This is a great utility! Thanks for sharing!!

  • @sue_bayes
    @sue_bayes3 жыл бұрын

    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.

  • @martingoedhart2294
    @martingoedhart22943 жыл бұрын

    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.

  • @Fernando_Calero
    @Fernando_Calero3 жыл бұрын

    Powerful presentation Adam

  • @Gergoo1991
    @Gergoo19913 жыл бұрын

    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.

  • @tukaramjogdand7023
    @tukaramjogdand70232 жыл бұрын

    You gave amazing insights and pro expertise to apply in our reports.

  • @ranimaharaj-sharma4332
    @ranimaharaj-sharma4332 Жыл бұрын

    Great video.. I did not even think about switchingvisuals..Thanks so much..

  • @jaybetz2070
    @jaybetz20702 жыл бұрын

    Awesome! Exactly what I was looking for.

  • @seema_shahabkhan
    @seema_shahabkhan3 жыл бұрын

    ya this i have been using except the selected visuals part, again an awesome video and really valuable

  • @gabrielabarrera1983
    @gabrielabarrera19832 жыл бұрын

    I didn't even know I needed this so much LOL. Thanks so much!!!

  • @charlesparriet3992
    @charlesparriet39923 жыл бұрын

    Thanks for sharing, slowly coming together...

  • @renatonappo3630
    @renatonappo363011 ай бұрын

    Great video. Somewhat comforting, I've already done this to show/hide charts. Yay.

  • @andregiordano47
    @andregiordano47 Жыл бұрын

    Wonderful content. Thanks for that!

  • @gonzispace
    @gonzispace3 жыл бұрын

    Excelente vídeo, muchas gracias por toda la información que brindan.

  • @ChrisSmithFW
    @ChrisSmithFW2 жыл бұрын

    Awesome! Super-friggin-cool. Solved a problem I've been grappling with for a few weeks now! Thanks so much.

  • @maheshgupte1495
    @maheshgupte1495 Жыл бұрын

    Thank you for this video finally I have done this

  • @tywilkinson469
    @tywilkinson4692 ай бұрын

    This is amazing! Thank you!

  • @kylegautreaux9257
    @kylegautreaux92572 жыл бұрын

    Beautiful! Thanks so much, this just saved my final page of my project. Kudos!

  • @ITyraxI
    @ITyraxI3 жыл бұрын

    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!

  • @S8CTION
    @S8CTION2 жыл бұрын

    You guys are amazing!

  • @jdg12800
    @jdg128003 жыл бұрын

    Great tip. Can't wait to use this.

  • @DanielHernandezCa
    @DanielHernandezCa Жыл бұрын

    Thank you! I just used it!! :D❤

  • @GLozadaC
    @GLozadaC2 жыл бұрын

    This is great , I am definitely using it.

  • @jontybuk
    @jontybuk3 жыл бұрын

    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

  • @wuajaz91
    @wuajaz912 жыл бұрын

    Thanks for the great video.

  • @oyebolaomoya381
    @oyebolaomoya3813 жыл бұрын

    Great insight.Gonna try out.

  • @dhawalpmehta
    @dhawalpmehta3 жыл бұрын

    Very useful, i have used this trick but Selected Visual is new for me. As always thanks for sharing :)

  • @gerryabramovich8739
    @gerryabramovich87393 жыл бұрын

    Thank you !

  • @lilianaacosta9665
    @lilianaacosta96652 жыл бұрын

    Just what I needed

  • @user-eg6gq7rm8j
    @user-eg6gq7rm8j3 ай бұрын

    Thanks. It helps a lot

  • @haristotal
    @haristotal3 жыл бұрын

    Awesome insight!

  • @amitgoyal7189
    @amitgoyal71892 жыл бұрын

    great work

  • @UlyssesBuragay
    @UlyssesBuragay Жыл бұрын

    found the solution right away thanks for this!

  • @nidhikafalia1263
    @nidhikafalia12632 жыл бұрын

    This was so great.. such a great fix with such simple explanation!!! Thanks a lot..:):)

  • @sholder9933
    @sholder99332 жыл бұрын

    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.

  • @Abhijithjj
    @Abhijithjj Жыл бұрын

    Thank you so much

  • @StephanieRodgers-cj9ne
    @StephanieRodgers-cj9ne2 ай бұрын

    This is really baller. Thank you!

  • @CaptiaNIFTY
    @CaptiaNIFTY Жыл бұрын

    Exactly what I needed 🥰

  • @GuyInACube

    @GuyInACube

    Жыл бұрын

    BAM!

  • @rutastasytyte4372
    @rutastasytyte43722 жыл бұрын

    You're the only Power BI channel that doesn't add to my new pet peeve - Power BI videos.

  • @sandeepg4705
    @sandeepg47053 жыл бұрын

    Thank you

  • @jgtrudeau
    @jgtrudeau3 жыл бұрын

    #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

  • @reinerweisssieker7033
    @reinerweisssieker70333 жыл бұрын

    Great Stuff

  • @niravdesai2399
    @niravdesai23993 жыл бұрын

    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 ?

  • @Cthames123
    @Cthames1232 жыл бұрын

    Blew my mind!

  • @amarkhaliq6749
    @amarkhaliq67492 жыл бұрын

    what a tip that I am using in my report have those arrows inside the visualizations. thanks

  • @PedroCabraldaCamara
    @PedroCabraldaCamara3 жыл бұрын

    that is amazing!!

  • @jaco7433
    @jaco74333 жыл бұрын

    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 .

  • @nayi421
    @nayi421 Жыл бұрын

    great video, can this be done for all graphs within the page?

  • @MichaelTKleven-MC
    @MichaelTKleven-MC3 жыл бұрын

    Thanks for the intro to Bookmarks & Buttons. #MasterBookmarks

  • @RichardOliver
    @RichardOliver3 жыл бұрын

    #masterbookmarks - I've never really had a satisfactory explanation of 'selected visuals', so this would be useful.

  • @bijilashobanabalakrishnan7718
    @bijilashobanabalakrishnan77183 жыл бұрын

    Amazing 🤩

  • @crlrealms9606
    @crlrealms9606 Жыл бұрын

    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?

  • @kannanm6039
    @kannanm6039 Жыл бұрын

    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!...

  • @pbihari0214
    @pbihari02143 жыл бұрын

    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.

  • @HuffrsZoe
    @HuffrsZoe2 жыл бұрын

    I needed this!!! #MasterBookmarks

  • @JackIrby
    @JackIrby3 жыл бұрын

    Great video, as usual. Yes, #MasterBookmarks

  • @KD-xy8kq
    @KD-xy8kq Жыл бұрын

    Thanks buddy. exactly what i was looking for. May God Bless You! Jai Shri Ram!!

  • @joaorataoo
    @joaorataoo3 жыл бұрын

    Very good. I finally realized what the 'Visuals' option is for. #masterbookmarks

  • @danielsiffredi8403
    @danielsiffredi84033 жыл бұрын

    #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!

  • @mazevedopro
    @mazevedopro2 ай бұрын

    I luv you guys

  • @roscaacinitram3058
    @roscaacinitram3058 Жыл бұрын

    Excelente

  • @annela09
    @annela09 Жыл бұрын

    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?

  • @NaraMeerammaTrust
    @NaraMeerammaTrust3 жыл бұрын

    Can i download this file? if so from where? Appreciate if you can let me know. Thank U

  • @jekyllhyde9037
    @jekyllhyde90373 жыл бұрын

    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)

  • @abhishekarora1
    @abhishekarora12 жыл бұрын

    How to switch the visuals based on slicer selection and all instead of button? Any workaround pls

  • @mrsmrk0771
    @mrsmrk07712 жыл бұрын

    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.

  • @priyankakumar3207
    @priyankakumar32073 жыл бұрын

    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????

  • @maurojk
    @maurojk25 күн бұрын

    Q: can i do that wired to a data condition? instead of clicking ? example.. if there is active alerts. i want to swap to Alert Listing Visual. but is there is no active alert i want to swap to Goal Achivements visual. automaticaly based on de data update of the dash that ocours on time bases of 10 minutes

  • @ashwin147
    @ashwin1473 жыл бұрын

    Thanks Adam it is a great video #masterBookmarks

  • @visheshjjain
    @visheshjjain3 жыл бұрын

    Please can you do a video on how to add a scroll bar to the whole page to add more visuals. Thanks!

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa17 күн бұрын

    Hi, After clicking on any slicer or datapoint in any Slicer/Visual, if we toggle the view or change the view in the same page of the power BI report, it again shows whole report rather it should show the filtered report. How can it be achieved?

  • @user-ht9ct4ih8p
    @user-ht9ct4ih8p7 ай бұрын

    Let's suppose if it has date drop and I want display the one visual for latest date and another visual previous dates. can we achieve that functionality

  • @mustafabiviji00711
    @mustafabiviji007113 жыл бұрын

    #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

  • @RavitThapar29
    @RavitThapar293 жыл бұрын

    How does this impact performance? I have 10 buttons for 10 KPIs and every button click swaps 2 visuals (card & trend) relevant to that KPI. Does this impact performance even though other 18 visuals (associated with other 9 buttons) are hidden at any given point?

  • @zachariahabraham3356
    @zachariahabraham33568 ай бұрын

    hello, i would like my filtering on one visual to carry over when i do that change .. can someone help me out pls

  • @snkhan6878
    @snkhan68783 жыл бұрын

    What exactly the difference is all visuals and selected visuals. I didn't get it. But as always great video... really helpful.

  • @alpesh417rt
    @alpesh417rt3 жыл бұрын

    great video - but i really enjoyed the matrix funny stint of 2 sec

  • @brooksschumacher7463
    @brooksschumacher74633 жыл бұрын

    Great Video! Can't wait to use this in my current reports or new reports. #masterbookmarks

  • 3 жыл бұрын

    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

  • @juanignacioXI
    @juanignacioXI3 жыл бұрын

    #MASTERBOOKMARKS Oh yeaaah!!

  • @davidmoe4167
    @davidmoe41673 жыл бұрын

    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.

Келесі