Forum Discussion
How to use bookmarks with time intelligence functions
Hi all
I saw some time a ago a COVID dashboard from MSFT and I really liked their approach to present the cases.
They have 2 buttons or boorkmarks, which shows you the daily cases and cumulative cases. By just clicking either button, you get the graph uptaded in the same place:
I would like to have something similar, for my 4 tables: 3M, YTD, 12M and the default measure. So instead of having 4 tables like this;
I would like to have something like the image below, being each text in the upper table the button of the bookmark:
So if you click on YTD, you should get the table updated with YTD values, and so on.
PBIX Covid: https://1drv.ms/u/s!ApgeWwGTKtFdhmV6BmKJbl8HXDee?e=zeY1HK
PBIX tables: https://1drv.ms/u/s!ApgeWwGTKtFdhmc6hMVmmqyeKKwZ?e=qfdqm8
Thanks!
Hi o59393
You can refer to the document:
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
And then insert the button with function equipped:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-buttons
You can find my detailed setting when you enable the view of bookmark and selection. also the action of the button in the visualization panel.
4 Replies
o59393 , for bookmarks, refer
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarksYou need to show hide.
In case you want change measure in the same visual
Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy
Appreciate your Kudos.Hi v-diye-msft
I see there is no dax associated. Can you provide the steps on how you did this if it's not a problem?
Thanks!
Hi o59393
You can refer to the document:
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
And then insert the button with function equipped:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-buttons
You can find my detailed setting when you enable the view of bookmark and selection. also the action of the button in the visualization panel.
