Dynamic axis based on slicer

[Anonymous]

Hello,

I have multiple graphs in one page and all of them use my Date Hierarchy as the Axis. I want to be able to change all Axis' graphs from Month to Week to Year etc without going through them one by one using the drill up and expand down.

I wanna have a slicer that has : Month, Week, Semester, Trimester and whenever i click on one all axis' change to the selected value. Is there a way to do so ?

Thanks in advance,

[selimovd · Accepted solution]

Hey @Anonymous ,

yes, you can use bookmarks for that.

Save a bookmark for the Month, then drill all of them to the next level like week and add another bookmark and continue like that for the other cases.

The bookmark you can then trigger with the click on a button.

See the details here:

Use bookmarks in Power BI Desktop to share insights and build stories - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic