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

J.Koopman on 05 Jul 2020 23:29:48

RE: Dynamic Constant Line for Targets/Benchmarks

Absolutely critical feature. Now we have to adjust the dynamic constant lines (warning / criticallity levels,etc) by hand, while the rest of the report is updated automatically.

James Ward's profile image Profile Picture

Federico on 05 Jul 2020 23:25:38

RE: Dynamic Constant Line for Targets/Benchmarks

This feature is essential.

James Ward's profile image Profile Picture

Power BI User on 05 Jul 2020 22:57:50

RE: Dynamic Constant Line for Targets/Benchmarks

This is an issue and causes redundancy in reporting. When you do not need a Full Summary report mirrored to provide Account Executive Levels (Same report different Levels). A Dynamic constant based on targets at levels is absolutely necessary.