Selecting a column based on slicer selection

[eltorr0]

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

[dkay84_PowerBI · Accepted 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.

[CAPEconsulting]

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

[eltorr0]

This worked flawlessly.  Can't believe it was that simple!.  Thank you!