Forum Discussion

BalaVenuGopal's avatar
BalaVenuGopal
Resolver I
8 years ago
Solved

How to Select multiple measures from list

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 cha...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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's avatar
morrtenjansen
Frequent Visitor
5 years ago

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