would be great if the reference line would compute averages and dynamically change, ala tableau and microstrategy..
Administrator on 25 Aug 2016 23:34:10
With the August release of Power BI Desktop, we added a new analytics pane that contains lots of dynamic reference line options for you to add to your visuals. To learn more about how it works, check out our latest blog post about the August release. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-feature-summary/
- Comments (31)
RE: dynamic reference lines
similar to reference lines in bar charts, but vertical user defined lines to visually separate line charts.
RE: dynamic reference lines
Reference lines should be available also for x-axis. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12284193-reference-line-for-x-axis
RE: dynamic reference lines
More and dynamic reference lines are necessary. You can kind of jury-rig it if you use the combined column-line chart, but the lines are all connected and sloped (not flat) so they look screwy.
RE: dynamic reference lines
If one splits a line chart by "legend" (for example: gender) should one be able to plot the total (female & male) as a reference line.
RE: dynamic reference lines
I came on here to suggest the exact same thing. We must be able to specify the reference line (aka base line) from a measure instead of a fixed value.
RE: dynamic reference lines
I need this too!
RE: dynamic reference lines
I really need this feature too
RE: dynamic reference lines
Reference line also for X-Axis
RE: dynamic reference lines
100% agree. sometime we need multiple ref lines for multiple measures in one chart
RE: dynamic reference lines
Bump. Would like to use a measure (e.g. Std deviation of a dataset) as a reference line in visuals such as clustered column chart.