cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VTran912 Frequent Visitor
Frequent Visitor

Dynamically Changing Date Level in Reports

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

 

 

Month_Slicer.JPGQuarter_Slicer.JPGYear_Slicer.JPG

 

 

 

3 REPLIES 3
Super User
Super User

Re: Dynamically Changing Date Level in Reports

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

VTran912 Frequent Visitor
Frequent Visitor

Re: Dynamically Changing Date Level in Reports

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.

Community Support Team
Community Support Team

Re: Dynamically Changing Date Level in Reports

Hi @VTran912

 

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.