Creating multi select slicer measure for a dynamic line chart

[Anonymous]

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 

[Anonymous]

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

Content	A	B

Just selecting B: 

Content	B

Selecting B,C

Content	B	C

and so on..

[v-lili6-msft · Accepted solution]

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]

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