Forum Discussion
Dynamic Dimension in Bar Chart x-axis
Below measue works when use this as a measure in the y-axis but I am not able to figure it out how to use similar thing for a dimension in x-axis. I want to achieve this without using field parameter.
I want to use the below dimension dynamically.
Fact1[Year]
Fact2[Year]
DynamicMeasure =
SWITCH(
TRUE(),
SELECTEDVALUE(Slicer1Options[Option]) = "Option A" && SELECTEDVALUE(Slicer2Options[Option]) = "Option X", [MeasureAX],
SELECTEDVALUE(Slicer1Options[Option]) = "Option A" && SELECTEDVALUE(Slicer2Options[Option]) = "Option Y", [MeasureAY],
SELECTEDVALUE(Slicer1Options[Option]) = "Option B" && SELECTEDVALUE(Slicer2Options[Option]) = "Option X", [MeasureBX],
SELECTEDVALUE(Slicer1Options[Option]) = "Option B" && SELECTEDVALUE(Slicer2Options[Option]) = "Option Y", [MeasureBY],
BLANK()
)
I wanted to use like below i am not able to use the dimension, i can use only measure
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.
7 Replies
- danextian
Super User
Hi Anonymous
From the looks of it, you're trying to create a calculated column using a slicer selection from SelectedDimension. That won’t work as calculated columns (and tables) don’t respond to slicers. Their values are fixed when the data is loaded or refreshed, so they won’t update based on user selections.
We may be able provide you with a workaround but we need a sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.
danextian I am not creating the calculated column. It is a direct column from a table only. Based on the selectedvalue of a slicer i wanted to control the dimension.
- danextian
You are trying to switch between dimensions using DAX exression which is not possible. Values from both columns must exist in a single column with another column to identify which row goes to a specific slicer selection. Please refer to v-pnaroju-msft's response. This should be possible though and pretty simple with Field Parameters - Let report readers use field parameters to change visuals (preview)
v-pnaroju-msftCommunity Support
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.
- v-pnaroju-msft
Hi pbiforum_123,
We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.
Thank you. - v-pnaroju-msft
Hi pbiforum_123,
We would like to know if the details we shared have helped solve your problem. If you require any additional assistance, feel free to connect with the Microsoft Fabric community.
Thank you. - v-pnaroju-msft
Hi 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.
