Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a challenge where I'm looking to switch column values of a matrix based on a slicer selection.
tblBusiness contains two columns (competitor1 & competitor2) which I would need to choose between when selecting the slicer.
The slicer values come from tblcompetitor which lists two values.
The output will be a matrix column selection dependent on the slicer "competitor" selection
Solved! Go to Solution.
You can unpivot your two columns in the query editor so that you have an attribute column (competitor) and a value column (whatever was in the previous two columns). Then you would just put the Competitor field into your slicer and the value field into your matrix.
You can unpivot your two columns in the query editor so that you have an attribute column (competitor) and a value column (whatever was in the previous two columns). Then you would just put the Competitor field into your slicer and the value field into your matrix.
WHat if unpivoting was not feasible as in a scenario of 1 million rows and 1000 columns.
Or if unpivoting was not an option in power bi. How would we solve this using measures and columns
This worked flawlessly. Can't believe it was that simple!. Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |