display different measures using a slicer - but not in the same column

[Anonymous]

Hi There

I am looking if there is a way how to modify this solution 

https://community.powerbi.com/t5/Desktop/How-to-display-different-measures-using-a-selector/m-p/1317...

I have region and countries on the rows and the actual year and last year are in values (see below)

I would like to create a measure for slicer that would display my data in this way 

Thank you 

[v-shex-msft]

Hi @Anonymous,

>>I would like to create a measure for slicer that would display my data in this way 

Current power bi not support hide exist columns by slicer.

It only support to create a dynamic measure who support to change display values based on slicer.

Sample:

Selector Table:

Selector = UNION(ROW("Type","VOL"),ROW("Type","vs Tager") )

Measure:

dynamic = 
var selected=IF(HASONEVALUE(Selector[Type]),VALUES(Selector[Type]),BLANK())
return
SWITCH(selected,"VOL",MAX(Sheet4[VOL]),"vs Tager",MAX(Sheet4[vs Tager])) 

Regards,

Xiaoxin Sheng