Forum Discussion
Dynamic Changing X Axis on Chart based on Slicer Selection
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
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
2 Replies
- v-lili6-msft
Community Support
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
- AnonymousNot applicable
Hi Lin
Just checking the links, and thanks very much for the excellent feedback.