No video
Swap Power BI Visuals to add FLEXIBILITY in your reports
Рет қаралды 140,152
Күн бұрын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/me...
*******************
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/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #Visuals #GuyInACube
@shamf6624 3 жыл бұрын
Doing it already but haven't used selected visual option. Thankyou for sharing
@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
@timgray7859 3 жыл бұрын
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.
@georgevandyke7486 4 ай бұрын
Fantastic Adam, thank you for the walk through! I used a similar technique in Tableau, but this seems easier 🤠
@gulhermepereira249 3 жыл бұрын
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
@rutastasytyte4372 2 жыл бұрын
You're the only Power BI channel that doesn't add to my new pet peeve - Power BI videos.
@drathman_DX 7 ай бұрын
Just used this technique in a project. Thank you for sharing!
@GuyInACube 7 ай бұрын
BAM! Great to hear!
@DarkOri3nt 3 жыл бұрын
Personalise visuals in the service also achieves this really well too. Such a good way to customise multplie visuals to the users needs
@martingoedhart2294 3 жыл бұрын
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.
@beyondtriggered4145 3 жыл бұрын
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 3 жыл бұрын
@@dylanvalencia349 yes. You would need 2 different graphs, stack them on top of each other and you would hide one in one visual
@KLMCats 3 жыл бұрын
LOVE layering pages, reduces overall page size while proviising maximum info
@harinisivakumar4500 2 жыл бұрын
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.
@michauJi 3 жыл бұрын
Short and sweet explanation. Love it!
@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 3 жыл бұрын
Had to do a really complicated report with the help of bookmarks, selections and data. Its nice to see how "Selected Visuals" is used
@brad7648 2 жыл бұрын
I love KZfaq 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 KZfaq and was exactly what I needed. Thanks for the great video, Adam!
@TheMrWARLORD 2 жыл бұрын
Just discovered this channel, and these guys are my favorite now :)
@tukaramjogdand7023 2 жыл бұрын
You gave amazing insights and pro expertise to apply in our reports.
@arnohoedelmans 3 жыл бұрын
Really great to know about all selected! Thanx Adam
@maheshgupte1495 2 жыл бұрын
Thank you for this video finally I have done this
@driouchemountasir7894 3 жыл бұрын
Awesome as usual GIAC team ! You rock
@tywilkinson469 3 ай бұрын
This is amazing! Thank you!
@ITyraxI 3 жыл бұрын
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!
@CaptiaNIFTY Жыл бұрын
Exactly what I needed 🥰
@GuyInACube Жыл бұрын
BAM!
@nawaazr5388 2 жыл бұрын
Incredible- definitely blew my mind! No more creating huge pages that are hard and non-intuitive to navigate. Thanks so much
@remembernaveen30 Ай бұрын
Great sir ..Thank u so much for your effort
@sue_bayes 3 жыл бұрын
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.
@jgtrudeau 3 жыл бұрын
#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
@jontybuk 3 жыл бұрын
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
@renatonappo3630 Жыл бұрын
Great video. Somewhat comforting, I've already done this to show/hide charts. Yay.
@GLozadaC 2 жыл бұрын
This is great , I am definitely using it.
@andregiordano47 Жыл бұрын
Wonderful content. Thanks for that!
@Gergoo1991 3 жыл бұрын
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.
@S8CTION 2 жыл бұрын
You guys are amazing!
@UlyssesBuragay 2 жыл бұрын
found the solution right away thanks for this!
@RichardOliver 3 жыл бұрын
#masterbookmarks - I've never really had a satisfactory explanation of 'selected visuals', so this would be useful.
@lilianaacosta9665 2 жыл бұрын
Just what I needed
@gabrielabarrera1983 3 жыл бұрын
I didn't even know I needed this so much LOL. Thanks so much!!!
@ranimaharaj-sharma4332 Жыл бұрын
Great video.. I did not even think about switchingvisuals..Thanks so much..
@niravdesai2399 3 жыл бұрын
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 ?
@DanielHernandezCa Жыл бұрын
Thank you! I just used it!! :D❤
@StephanieRodgers-cj9ne 3 ай бұрын
This is really baller. Thank you!
@sholder9933 2 жыл бұрын
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.
@ChrisSmithFW 2 жыл бұрын
Awesome! Super-friggin-cool. Solved a problem I've been grappling with for a few weeks now! Thanks so much.
@wuajaz91 2 жыл бұрын
Thanks for the great video.
@amarkhaliq6749 2 жыл бұрын
what a tip that I am using in my report have those arrows inside the visualizations. thanks
@user-eg6gq7rm8j 5 ай бұрын
Thanks. It helps a lot
@gerryabramovich8739 3 жыл бұрын
Thank you !
@crackerzin-bi6746 3 жыл бұрын
Same as you - mind blown! Great tip Adam - thanks for sharing it!
@dhawalpmehta 3 жыл бұрын
Very useful, i have used this trick but Selected Visual is new for me. As always thanks for sharing :)
@jaybetz2070 2 жыл бұрын
Awesome! Exactly what I was looking for.
@kylegautreaux9257 2 жыл бұрын
Beautiful! Thanks so much, this just saved my final page of my project. Kudos!
@seema_shahabkhan 3 жыл бұрын
ya this i have been using except the selected visuals part, again an awesome video and really valuable
@topher60657 3 жыл бұрын
Great timing Adam, I am going to use this solution today! Please keep up the great work!
@charlesparriet3992 3 жыл бұрын
Thanks for sharing, slowly coming together...
@malinthawijewardana6922 Жыл бұрын
Thank you
@Abhijithjj Жыл бұрын
Thank you so much
@Fernando_Calero 3 жыл бұрын
Powerful presentation Adam
@abhishekarora1 2 жыл бұрын
How to switch the visuals based on slicer selection and all instead of button? Any workaround pls
@seshadriraj 3 жыл бұрын
This is a great utility! Thanks for sharing!!
@Cthames123 2 жыл бұрын
Blew my mind!
@jdg12800 3 жыл бұрын
Great tip. Can't wait to use this.
@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!...
@jaco7433 3 жыл бұрын
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 .
@KD-xy8kq Жыл бұрын
Thanks buddy. exactly what i was looking for. May God Bless You! Jai Shri Ram!!
@amitgoyal7189 2 жыл бұрын
great work
@nidhikafalia1263 2 жыл бұрын
This was so great.. such a great fix with such simple explanation!!! Thanks a lot..:):)
@visheshjjain 3 жыл бұрын
Please can you do a video on how to add a scroll bar to the whole page to add more visuals. Thanks!
@oyebolaomoya381 3 жыл бұрын
Great insight.Gonna try out.
@pbihari0214 3 жыл бұрын
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.
@nayi421 Жыл бұрын
great video, can this be done for all graphs within the page?
@alpesh417rt 3 жыл бұрын
great video - but i really enjoyed the matrix funny stint of 2 sec
@gonzispace 3 жыл бұрын
Excelente vídeo, muchas gracias por toda la información que brindan.
@danielsiffredi8403 3 жыл бұрын
#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!
@snkhan6878 3 жыл бұрын
What exactly the difference is all visuals and selected visuals. I didn't get it. But as always great video... really helpful.
@jekyllhyde9037 3 жыл бұрын
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)
@reinerweisssieker7033 3 жыл бұрын
Great Stuff
@haristotal 3 жыл бұрын
Awesome insight!
@NaraMeerammaTrust 3 жыл бұрын
Can i download this file? if so from where? Appreciate if you can let me know. Thank U
@roscaacinitram3058 Жыл бұрын
Excelente
@AnshulMarele-gbaa 2 ай бұрын
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?
@MichaelTKleven-MC 3 жыл бұрын
Thanks for the intro to Bookmarks & Buttons. #MasterBookmarks
@mrsmrk0771 2 жыл бұрын
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.
@juanignacioXI 3 жыл бұрын
#MASTERBOOKMARKS Oh yeaaah!!
@mustafabiviji00711 3 жыл бұрын
#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
@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?
@priyankakumar3207 3 жыл бұрын
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????
@JackIrby 3 жыл бұрын
Great video, as usual. Yes, #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
@HuffrsZoe 2 жыл бұрын
I needed this!!! #MasterBookmarks
@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?
@jaydeepbiswas1 3 жыл бұрын
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.
@mazevedopro 4 ай бұрын
I luv you guys
@Maksim_Ikryanov Жыл бұрын
Like for the shirt!!
@ashwin147 3 жыл бұрын
Thanks Adam it is a great video #masterBookmarks
@ambreenkhan7620 5 ай бұрын
Can I switch over to a paginated report visual?
@denwo1982 2 жыл бұрын
This doesn’t’ work, as in if you select a value from one of the visualisations that is showing on the page it will filter the visualisations that are showing but then when you click the bookmark button it does not hold the filters, any reason why it would not this?
@user-ht9ct4ih8p 9 ай бұрын
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
@joaorataoo 3 жыл бұрын
Very good. I finally realized what the 'Visuals' option is for. #masterbookmarks
@nawaazr5388 2 жыл бұрын
Out of interest, how do you see the new field parameters capability fitting in here? they seem to be able to replace bookmarks/buttons when there is a common axis in visuals, and are much quicker/simpler to apply than bookmarks.
@maurojk 2 ай бұрын
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
Adam Finer - Learn BI Online
Рет қаралды 97 М.
Guy in a Cube
Рет қаралды 855 М.