Forum Discussion

eltorr0's avatar
eltorr0
Regular Visitor
9 years ago
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...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    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.

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
CAPEconsulting
Icon for Helper III rankHelper III
9 years ago

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