Dynamically change X-axis based on slicer selection

[ankitsuri26]

Hi, I am a beginner at power bi. I am creating a report to show benchmarking data. In the report i have a line chart which displays data based on dates. The dates include Day,month, year. I already have a slicer (Time Period) to show last 3 months, last 6 months data. Now i want to add another slicer (Time Aggregation)which shows data monthly vs quarterly. I am not able to figure out how to show this. I am aware about the drilldown on the chart and i dont want users to use this. Also bookmarks wont help since there are multiple slicer slection on the page. Can anybody help?

[v-xinruzhu-msft · Accepted solution]

Hi @ankitsuri26 

You can consider to use the field paramater so that you can change the x-axis dynamically.

You can refer to the following link know how to use the field paramater to change the axis.

Dynamic X Axis With Field Parameters in Power BI (youtube.com)

towardsdatascience.com.

The  following link is about the information about the field paramater.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.