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

[sh10]

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 July.

How can i perform this in Power BI?

INDEX('Cost Center AOP'!$G:$R,,MATCH($H$2,'Cost Center AOP'!$G$5:$R$5,0))

Cost Center AOP data

May   |    June   |      July   |     August    <---Column Name

$0            $1             $2              $3

$1            $2             $2              $2

$3            $3             $3              $3  

[v-yuta-msft · Accepted solution]

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