Skip to main content
Microsoft Idea

Power BI

Completed

dynamic reference lines

Vote (155) Share
's profile image

on 04 Apr 2016 04:16:48

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)
's profile image Profile Picture

Brian Carter on 05 Jul 2020 22:21:13

RE: dynamic reference lines

similar to reference lines in bar charts, but vertical user defined lines to visually separate line charts.

's profile image Profile Picture

Simone Frassanito on 05 Jul 2020 22:18:40

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

's profile image Profile Picture

Dan Ahlvin on 05 Jul 2020 22:18:28

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.

's profile image Profile Picture

Celine on 05 Jul 2020 22:18:23

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.

's profile image Profile Picture

Pedro Innecco on 05 Jul 2020 22:17:12

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.

's profile image Profile Picture

Garrett on 05 Jul 2020 22:16:41

RE: dynamic reference lines

I need this too!

's profile image Profile Picture

Mihai Barbulescu on 05 Jul 2020 22:16:41

RE: dynamic reference lines

I really need this feature too

's profile image Profile Picture

Simone Frassanito on 05 Jul 2020 22:15:59

RE: dynamic reference lines

Reference line also for X-Axis

's profile image Profile Picture

Nguyễn Minh Trí on 05 Jul 2020 22:14:33

RE: dynamic reference lines

100% agree. sometime we need multiple ref lines for multiple measures in one chart

's profile image Profile Picture

Jorge Segarra Rovira on 05 Jul 2020 22:13:57

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.