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

BalaVenuGopal's avatar
BalaVenuGopal
Resolver I
8 years ago

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

 

Is there any posibility to hide the unselected measure in legend