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 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'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

4 Replies

  • 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 

    • 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