Forum Discussion
Dynamically change X-axis based on slicer selection
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?
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)
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.
1 Reply
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)
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.