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
v-lili6-msft
Community Support
Community SupportHI, 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
How would you show only selected slicer value on legend? any idea?
