Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |