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.

  • eltorr0's avatar
    eltorr0
    Regular Visitor
    9 years ago

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

  • 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