Using Bookmarks to Toggle Hierarchy Levels Across Multiple Visuals in Power BI
HTML-код
- Опубликовано: 2 авг 2024
- Learn how to leverage bookmarks to seamlessly navigate between hierarchical time perspectives across multiple visuals.
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:12 - Content Intro
0:35 - Showing the Solution
1:46 - Opening Bookmarks Pane
1:59 - Opening Selection Pane
2:46 - Creating the Bookmarks
LET'S CONNECT! 🧑🏽🤝🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog - www.havensconsulting.net/blog-...
Blog Files - www.havensconsulting.net/blog-...
Files & Templates - www.havensconsulting.net/files...
Consulting Services - www.havensconsulting.net/consu...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop Наука
Good call with Bookmarks. I come from the Qlikview world and this can be done easily with "Dimension Groups". I really hope PBI puts something like this in in the future. Great vid!
Do you have a video or website that explains how to do this dimensions. I'd like to change the x-axis for a chart by picking items from a slicer, Year/Month/Day. When I select the year it shows all the years in the x-axis, when I select month it shows all the emonths for the current year todays date, and when select days the xaxis shows all the days for the current month todays date
Interesting tip, thanks!
Thanks!
You save my day, thank you very much
Exactly, what I have been looking for and with similar example 😀😀. Thanks Havens you saved my day 👊🏼👊🏼
Happy to help!
Great implementation of bookmarks. It really makes a difference from a user experience perspective. It feels a bit tedious sometimes to configure all, but it's worth it. 🙏
Agreed! Features are better for the end-user, not the developer with bookmarks, haha. But worth it!
Glad You're supporting this too ...
Hi Reid, I always like the buttons/bookmarks solution. What I find hard to use in this case is to have data enabled in the bookmark since it kind of limits the use of rest of the filters on a page. Hence I mostly end up with multiple charts to flip between. Something that does work well for something as easy as a calendar is the use of an unpivoted table. Then the Quarter,Month and Day became a value in a dimension and you can easily toggle between them
Hi Joost, good comments. One benefit of using selected visuals, is that even with data checked, any slicer selections or filters still won't be reset, as long as those visuals weren't selected upon bookmark states capture
Hi Reid,
Excellent video! How Do you switch the chart title dynamically? I'm trying to change it on , but I can just select one title...
Through bookmarks selected visual and hide/show the visual on the selection month/day/quarter. (You need to create three visual)
Nice video. Will you also be making the .pbix available via your downloads page? Thanks.
Absolutely, it is in there now
What was the your title background color hex code?
Hi Sandeep, you can find that info in the file if you visit our files page.
Hi , Great video , how do I do the same across pages meaning , same function should repeat globally to all pages , is this doable ?
Unfortunately no, bookmarks just capture per page, not across all pages. The only work arounds I can think of for this would be too complex to explain in just a RUclips comment
@@HavensConsulting Thanks for your reply .
good solution - it is possible to create the same in dax though 🙂
Never know about DAX if you don't mind please share anylink I can use for references
Can I download this file, I can't see it in your website
It’s available to download from my blog files page on my website www.havensconsulting.net/blog-files
@@HavensConsulting I followed this link but It said I must to sign up and direct to your website but I can't see the sign up button. Pls help ! Tks u so much
@@tienphamthanh5105 click the words "Blog page" on the above link page. That is a underlined hyperlink. That will take you to my Blog Page, where the signup form access is on the right side.
Can we have a workaround applied to multiple pages?
Sadly with a bookmark implementation it only works per page for each bookmark. No way to capture across pages.
how to remove CTRL + Click to go bookmarks page link for click on button
Hi there. Control click will always be required when working in PBID. As it’s meant to make sure developers don’t accidentally activate a bookmark unintentionally. Once published though buttons only require a click (no control)