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.
PowerBI desktop version 2.86 introduced a secondary Y axis in the line chart. I am unable to drag a value in that chart. I want to allow the user to select multiple values, some are total number of meetings and the other are percentages, so the scales are different. If I drag a Value into the Value field, I can't drag something in the Secondary values field or vice versa. Is this an issue with the data or a bug?
Solved! Go to Solution.
I understand what you are trying to achieve but if legend cant actually help, in this case the alternative would be to create a separate measure for each value in UsageName field.
Based on the highlighted values (red and green - 4 in total) you will have to create 4 measures and add them to the visual. 2 in primary and 2 in secondary axis
That partially helps so thank you for that. The other issue I have having now is that it aggregates the values instead of creating a single line for each selection. For example, I'd want a line for each of the selection so there would be 4 in the case. What is happening is the two items in red are being aggregated and the two items in green are aggregated, so I only have 2 lines.
I tried this and it worked. I added two different metrics to a "Stacked Column Chart" on the Y-Axis - [LastYearTotals] & [CurrentYearTotals] of course with a [MonthName] on the X-Axis. I then change the chart from a "Stacked Column Chart" to a "Clustered Column Chart" and now I can see two Y-Axis.
Here is a sample of my data...
I understand what you are trying to achieve but if legend cant actually help, in this case the alternative would be to create a separate measure for each value in UsageName field.
Based on the highlighted values (red and green - 4 in total) you will have to create 4 measures and add them to the visual. 2 in primary and 2 in secondary axis
Thanks, I actually will need more measures but let me try that. I'll accept as solution if I can get it work.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |