Forum Discussion
Solved
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 betwee...
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.
This worked flawlessly. Can't believe it was that simple!. Thank you!