Show multiple measure based on single slicer selection

Hi,

According to your description, I create a table to test:

Please take following steps:

1)Create six measures like you:

OOG CY = SUM(Sales[Sales])

OOG PY = SUM(Sales[Sales])*10

IIF CY = SUM(Sales[Sales])*20

IIF PY = SUM(Sales[Sales])*30

ZF CY  = SUM(Sales[Sales])*40

ZF PY  = SUM(Sales[Sales])*50

2)Create a table by ‘Enter Data’:

3)Create a measure to display what you want:

Measure

= SWITCH(SELECTEDVALUE(SlicerTable[SlicerValue]),"OOG CY",[OOG CY],"OOG PY",[OOG PY],"IIF CY",[IIF CY],"IIF PY",[IIF PY],"ZF CY",[ZF CY],"ZF PY",[ZF PY])

4)Choose [BelongTo] as a slicer and the result shows:

Here is my test pbix file:

pbix 

Best Regards,

Giotto Zhi

Bravo ! My issue is fixed. Thanks much !

Hi,

Please add a new column [Index] in Query Editor:

Then, change this table sort by [Index] in Modeling pane:

And the visual shows the PY first and CY second:

Best Regards,

Giotto Zhi

It did work. Thanks !