Forum Discussion

sh10's avatar
sh10
New Member
8 years ago
Solved

Excel Index Match to retrieve a data column based on selected value

Hello! I did a formula below in Excel to get a column of data based on the selected value in a Slicer. For example, if a user select July in the slicer, it returns me the row of column values for Ju...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi sh10,

     

    You can't do this directly in power bi because all the filter is based on rows, not columns. As a workaround, you can click-> query editor-> transform-> unpivot columns as below:

     

     

    After applied&closed, create a slicer visual based on attribute column like below:

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi sh10,

 

You can't do this directly in power bi because all the filter is based on rows, not columns. As a workaround, you can click-> query editor-> transform-> unpivot columns as below:

 

 

After applied&closed, create a slicer visual based on attribute column like below:

 

 

Regards,

Jimmy Tao