Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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..
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
How would you show only selected slicer value on legend? any idea?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |