dynamic reference lines
would be great if the reference line would compute averages and dynamically change, ala tableau and microstrategy..
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/
Olivier Travers commented
You can actually use a calculated measure in the analytics pane by 1) charting your measure in the chart's values, 2) adding it as a line in the analytics pane (as Min/Max/Average, since Constant accepts only hard-coded numbers), 3) styling it to your liking, and 4) moving the measure to tooltips.
This is however very clunky and almost impossible to discover if you don't know that's possible. Instead, the Analytics pane should let us pick any measure (doesn't need to be in the chart's fields) similarly to how the new expression-based formatting works.
Chris Taylor commented
Would be great if you can add a dynamic line based on a measure. I'm working with the horizontal stacked bar chart, displaying a single bar made up of actual sales and projected sales. I want to be able to show the budget as the target, but the only way to achieve this currently is to manually type the budget value in. If I could drag my "Budgets" measure into this, I'd be sorted.
Any update as to whether the addition of a dynamic reference line based on a calculated measure is in the works?
More is needed than just basic summary statistics. Greater flexibility would be provided by allowing the user to set a dynamic reference line based on a calculated measure. Is this in the works?
The update is only available in a few visuals. How about in a stacked column/bar chart where i can show the target value as a line and the pipeline and actual income as a stacked bar/column and that is dynamic and not constant!!
Why is this not available for stacked charts? I want to be able to add a reference line to a bar chart that's split out by legend but have the line change depending on the month filtered. However for a stacked bar chart only input constant is available.
please add this!
Aasheesh Chari commented
how do i add a dynamic reference line to a bar graph where the reference line refers to targets for each sales person or region and if the filter is used to select that particular sales person or region then the graph should change accordingly. Existing options for reference lines is minimal compared to tableau where I can map the reference lines to a data source containing targets against each category (i.e sales person, region or product line etc etc)
Combined with row level security, this will be extremely useful.
Great to hear that dynamic reference lines will finally be available!
Should be like SSRS where you can add multiple as well; à la strip lines of which an expression can be used.
Very much required, may be integrated with KPI
Ryan R commented
Multiple colored lines would be great. This allows us to show help desk expected response time for high, medium and low cases on the same chart. Now I only can show one reference line.
Fantastic, Nick! This would be immensely useful!
How does this only have 29 votes? This is needed for any kind of dynamic dashboard that allows user changes.
Bilal Yousuf commented
Yes please. I've been banging my head against the wall to try and do this!
Yes, multiple reference line who get data from measure.
And possibility to set as average, Median, count of rows, distinct count of rows,....
David Lean commented
I'd like to be able to add multiple reference lines. And make them either fixed (eg: 80% & 20%) or variable (eg: each driven by a measure, say 1 Std Dev above & 1 Std Dev below)
This would permit me to show things like :-
1. An Acceptable range. Anything too high or low is bad.
2. A typical range. where Std Dev would highlight outliers.
3. A set of Good, better, best lines. eg: sales targets often have a minimum acceptable value where you qualify for a performance bonus, The sales target, an accelerator when you get a bonus for exceeding your target. & maybe an extreme accelerator target.
Would also be great if I could use the reference line to control color.
A. The background color above the line was different to that below the line. eg: It could be light red & the normal background was white.
(for examples look at a stochastics chart in share trading. Often the background above 80 & below 20 are colored to show they are extreme values)
B. When a value exceeds the reference the bar or line changes color. (We can kinda do some of that today, but only one value)
Brian Carter commented
similar to reference lines in bar charts, but vertical user defined lines to visually separate line charts.