Dynamically Changing Date Level in Reports

[Anonymous]

Hi all,

I am trying to create a slicer for Months, Quarters, and Years to dynamically change the laytout for all the visual in one report. I have successful created this in Tableau, but I am unable to have this working in Power BI. Any help or guidance on this issue is appreciate.

Thanks everyone

[jthomson]

Surely it's easier to use a hierarchy and drill up/down levels rather than use a slicer?

[Anonymous]

Hierarcy and drill down function need to be selected by the user for all the graphs in this report, which I don't prefer for the user to do. Because I will have more than 2 graphs in this report, which will caused them to go over a single graphs to drill down for.

[v-cherch-msft]

Hi @Anonymous

You may try to use HierarchySlicer or have a look at below similar thread which has provided a valid solution to dynamically show X-axis dimension.

https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167

Regards,

Cherie