How to Select multiple measures from list

[BalaVenuGopal]

Dear All,

I have created 4 measures called M1,M2,M3,M4

1) I want to display these 4 measures in dropdown list what ever i have choosen that measure needs to be displayed on my chart (Line chart) so in this case measure is dynamic.[ i have created table with display measure and acutual measue as columns and used switch case which is working fine]

2) Above logic is working fine with 1 measure at a time.But i want to select multiple measures like i will make slicer properties and allow multiple selectin to true if i have choosen M1,M2 from list grapth should display these two measures.

Any help or any idea pease.!!!!!!!!!!

[v-yulgu-msft · Accepted solution]

Hi @BalaVenuGopal,

In that case, there is no need to create an extra measure using SWITCH function to dynamically change measures depend on slicer selection. You should modify the four measures similar to below, and add all of them into visual.

M1 = IF(CONTAINS('Slicer table','Slicer table'[Measures],"M1"),[Measure1],BLANK())

M2 = IF(CONTAINS('Slicer table','Slicer table'[Measures],"M2"),[Measure2],BLANK())

M3 = IF(CONTAINS('Slicer table','Slicer table'[Measures],"M3"),[Measure3],BLANK())

M4 = IF(CONTAINS('Slicer table','Slicer table'[Measures],"M4"),[Measure4],BLANK())

Reference: Dynamically select measures to be shown on a Power BI visual via slicer

Best regards,

Yuliana Gu

[morrtenjansen]

This is great, but it does not work for me in a "Matrix" visual, with the 'shy' measures [M1, M2 etc. parallels] as Values. (I did make sure that "Show items with no data" is not set meaning there is no checkmark showing by that option)

For testing I made a measure x = BLANK() and put that in the Values section also, and even that showed up as rows (with blank values, of course).

Any fix/workaround for this ?

Br, Morten

[BalaVenuGopal]

Awesome Thanks alot !!!!!!!!!!!

Is there any posibility to hide the unselected measure in legend