Dynamic Changing X Axis on Chart based on Slicer Selection

[Anonymous]

Hi Experts

Not sure how to do the following, Need a way using three slicers or another means to have the ability to do the following ie.  dynamically change the x axis to reflect the following:

1. User Selects Year and only the years are show as in the PBIX in the link.

2. User Selects a particular year and that years is only shown

3. Then as per point 2. user has the ability to select months on next slicer and all the months for that year are shown.

4. Then if the user want to change months to Quarter periods in that year thay can.

See Link: https://www.dropbox.com/s/q5jzjhngq4q6jav/Test_Data.pbix?dl=0

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Based on my research, for your requirement, I'm afraid it couldn't achieve in Power BI for now.

As a workaround, Please have a look at these posts to check if it could help you.

https://radacad.com/dynamic-x-axis-on-charts-power-bi

https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/

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

Best Regards,

Lin

[Anonymous]

Hi Lin

Just checking the links, and thanks very much for the excellent feedback.