Forum Discussion
Dynamic Dimension in Bar Chart x-axis
Thankyou, danextian, for your response.
Hi pbiforum_123,We appreciate your question on the Microsoft Fabric Community Forum.
From what I understand, you want to switch the X-axis between Fact1[Year] and Fact2[Year] based on a slicer selection, but without using Field Parameters. Since Power BI does not allow changing the X-axis dimension dynamically using only DAX, we have implemented a workaround using data modeling.
Kindly find the steps below to resolve the issue:
- Combine Fact1 and Fact2 tables using Power Query Append Queries to create a single table.
- Create a slicer using a Threshold Unit table.
- Use a DAX measure to filter data according to the slicer selection.
- Plot Year on the X-axis and the filtered Sales measure on the Y-axis.
This way, you can switch the dimension dynamically without using Field Parameters.
Please see the attached screenshot and sample pbix file for your reference:
We hope this helps you solve the issue. If you have any more questions, feel free to ask the Microsoft Fabric community.
Thank you.
Community SupportHi pbiforum_123,
We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution, as this helps the broader community.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.