Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to 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)
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.
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.