How to use bookmarks with time intelligence functions

[o59393]

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!

[v-diye-msft · Accepted solution]

Hi @o59393 

Let me know if you'd like to get below one:

Pbix attached.

[v-diye-msft · Accepted solution]

Hi @o59393 

Let me know if you'd like to get below one:

Pbix attached.

[o59393]

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!

[v-diye-msft · Accepted solution]

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.

[amitchandak]

@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-bookmarks

You need to show hide.

In case you want change measure in the same visual

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy
Appreciate your Kudos.