Forum Discussion
Selecting a column based on slicer selection
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
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.
3 Replies
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.
This worked flawlessly. Can't believe it was that simple!. Thank you!
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
