Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating multi select slicer measure for a dynamic line chart

Hi all, I have been successfully been able to make a dynamically customizable dual y-axis line chart using measures and slicing it. But, I want to hear if it can be taken to the next level and using the slicers to make multi select, and hence get multiple lines rather than the current limit of 2 selections. 

 

Current setup is using SWITCH and a manually entered table to direct to the data source.

 

This is where I am at - 

 

 

Any way to upgrade on the current DAX query to get to a multi select dual axis line chart? 

 

Thanks, Ziyad 

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    You could try this way as below:

    For all your basic measure add a if conditional like below:

     

    Measure 1 = IF("A" IN VALUES('Y axis 1'[Measurement 1]), CALCULATE(SUM(Table1[Index])))
    Measure 2 = IF("B" IN VALUES('Y axis 1'[Measurement 1]),CALCULATE(SUM(Table1[Sales])))
    Measure 3 = IF("C" IN VALUES('Y axis 1'[Measurement 1]), CALCULATE(SUM(Table1[Sales]),ALL(Table1)))

    Then drag all these measrue into line Values.

    Result:

     

    You could use the same logic for 'Y axis 2',

    Here is sample pbix file, please try it.

     

     

    Best Regards,

    Lin

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    HI, Anonymous 

    You could try this way as below:

    For all your basic measure add a if conditional like below:

     

    Measure 1 = IF("A" IN VALUES('Y axis 1'[Measurement 1]), CALCULATE(SUM(Table1[Index])))
    Measure 2 = IF("B" IN VALUES('Y axis 1'[Measurement 1]),CALCULATE(SUM(Table1[Sales])))
    Measure 3 = IF("C" IN VALUES('Y axis 1'[Measurement 1]), CALCULATE(SUM(Table1[Sales]),ALL(Table1)))

    Then drag all these measrue into line Values.

    Result:

     

    You could use the same logic for 'Y axis 2',

    Here is sample pbix file, please try it.

     

     

    Best Regards,

    Lin

    • powerbispider's avatar
      powerbispider
      Regular Visitor
      3 years ago

      How would you show only selected slicer value on legend? any idea?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Similar to the above use case for adding dynamic measure for a line chart, how do I create a measure to select columns dynamically based on the selection I make in the measure.

    For Eg: I have three measures A,B,C. Upon selecting A,B -> I get a table like below

    ContentAB
       

     

    Just selecting B: 

    ContentB
      

     

    Selecting B,C

    ContentBC
       

     

    and so on..