Skip to main content
Microsoft Idea

Power BI

Needs Votes

Dynamic Constant Line for Targets/Benchmarks

Vote (100) Share
James Ward's profile image

James Ward on 10 Jul 2017 23:13:55

Allow constant lines in Power BI to be driven by a measure. There is a need to have targets or benchmarks that are dynamic based on other selections on the page and these items could change at different points in time. Currently the constant feature for graphs on the Analytics pane requires values to be hardcoded/entered.

Comments (13)
James Ward's profile image Profile Picture

Tyler Bunger on 15 Mar 2023 18:30:05

RE: Dynamic Constant Line for Targets/Benchmarks

Need this feature to show what has changed in our manufacturing process.

James Ward's profile image Profile Picture

Dennise Joyce Reyes on 17 Aug 2022 06:42:34

RE: Dynamic Constant Line for Targets/Benchmarks

It has been years and this should be a priority. Everything needs a custom target.

James Ward's profile image Profile Picture

Adam Brown on 29 Oct 2021 22:42:19

RE: Dynamic Constant Line for Targets/Benchmarks

This would be extremely helpful. Also, if that line could be a range between 2 points

James Ward's profile image Profile Picture

Edwin de Ligter on 06 Jul 2020 00:11:58

RE: Dynamic Constant Line for Targets/Benchmarks

Not able to make a line graph with multiple lines and (dynamic) target lines based on a column or measure. This would solve it and make it all so much better.

James Ward's profile image Profile Picture

Stephen Paine on 06 Jul 2020 00:07:47

RE: Dynamic Constant Line for Targets/Benchmarks

This is the only drawback with Power BI - the way constant lines (etc) can't be substituted with measures. I need to add lines for Mean, Max and Min which dynamically adjust based on the filter selected - this isn't possible at the moment.

James Ward's profile image Profile Picture

Power BI User on 06 Jul 2020 00:05:49

RE: Dynamic Constant Line for Targets/Benchmarks

vote+1

James Ward's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:36

RE: Dynamic Constant Line for Targets/Benchmarks

Vote +1

James Ward's profile image Profile Picture

Power BI User on 05 Jul 2020 23:38:52

RE: Dynamic Constant Line for Targets/Benchmarks

Absolutely a must!

James Ward's profile image Profile Picture

Matt on 05 Jul 2020 23:38:48

RE: Dynamic Constant Line for Targets/Benchmarks

Terrific idea! A must add!

James Ward's profile image Profile Picture

Power BI User on 05 Jul 2020 23:30:12

RE: Dynamic Constant Line for Targets/Benchmarks

This Feature will help us to dynamically view the data as per the changing targets.