Forum Discussion
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 ...
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
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..