display different measures using a slicer grouped

[Anonymous]

Hi 

I am looking for an upgrade to this solution 

https://community.powerbi.com/t5/Desktop/dynamic-table-thanx-to-slicer/m-p/235057#M104628

I have reagion and country in the rows and actual yer and last year meassures per order type in the values.

I would like to create a slicer that will only show the measures which are relevat for the selected order type 

something like this. 

Please can someone help 

Thank you 

[v-sihou-msft]

@Anonymous

No, it's not possible to dynamically select multiple measures/columns into visual based on the selection in Slicer. You should re-modeling your table, add a Order Type column in your table and populate that Order Type column into matrix as Column Group, instead of have one measure for each Category.

Regards,

[Anonymous]

hi @v-sihou-msft

Please can you elaborate on "populate that Order Type column into matrix as Column Group"

I already have Order type in my table and I am using it for the slicer

Thank you