Clarke on 09 Sep 2015 05:51:53
We should be able to put two values and a legend on the same line chart.
- Comments (101)
- Merged Idea (1)
RE: two values and legend on line chart
We need atleast 5k votes on this to get picked up by the Power BI dev team.
RE: two values and legend on line chart
Seriously, Power BI needs to include this update in their next release. This can be achieved used python visual otherwise, but the formatting becomes a bit cumbersome with that.
RE: two values and legend on line chart
Is there any sort of workaround until PowerBI adds this feature?
RE: two values and legend on line chart
As everyone else said - this should be a no-brainer feature. In fact, you can already have two values and a legend in the "line and clustered column chart", but for some reason the second value is disabled when using a legend in the "line chart".
RE: two values and legend on line chart
Same as everybody else on here - I can't believe these aren't standard features. It's bonkers a piece of BI software can't do basic charts. Another very basic issue is clustered line and bar chart, when the secondary Y-axis is switched off so the second Y-axis dataset should revert to scale with the primary Y-axis, the secondary Y-axis labels just disappear but it doesn't scale. Plenty of research suggests it's simply not possible without workarounds managing the min/max scale of a secondary axis to force it to match the primary. This functionality is available in Excel so this is really annoying.
RE: two values and legend on line chart
I would like to add a second Values field to a line chart that already has an Axis: Date, Legend: Brand, and Values: $ Volume.
The second field would be $ Volume Year Ago and would be presented in the same color as the Brand but with a dashed line.
RE: two values and legend on line chart
This is something that should have been added from the start
RE: two values and legend on line chart
Paraphrasing another voter: being able to compare subsets of the total (with legend) against the total should be a no-brainer feature
RE: two values and legend on line chart
This function is essential!Next to my Y-values it must be possible to plot the values/curves for my lower and upper tolerance. Therefore, I must be able to plot at least 3 values while adding a legend! Same problem with the secondary axis - it's not possible to have a legend AND values and the Y-axis AND a secondary Y-axis.
RE: two values and legend on line chart
I also find it hard to believe this isn't a standard functionality in a dedicated reporting tool. Having more than one measure in a chart is essential, otherwise we'll have to revert to Excel or another BI product.