dynamic reference lines

[bw4]

would be great if the reference line would compute averages and dynamically change, ala tableau and microstrategy..

[wade_mcgriff]

Should be like SSRS where you can add multiple as well; à la strip lines of which an expression can be used.

[uldis_rats]

Great to hear that dynamic reference lines will finally be available!

[jerein01]

Combined with row level security, this will be extremely useful.

[aasheeshchari]

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)

[lenmazur]

please add this!

[Laura_East]

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.

[yash14vashisth1]

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!!

[mpbartee]

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?

[mpb17]

Any update as to whether the addition of a dynamic reference line based on a calculated measure is in the works?

[chris_taylor]

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.