Skip to main content

Power BI

New

Dynamic Constant Line for Targets/Benchmarks

Vote (86) 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 (10)
James Ward's profile image Profile Picture

11515bb0 9217-4615-b7cd-b3292c764eb0 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

4fa3f784 def2-4c11-b2ba-69e86ff7bf2b 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

bcddff2d f34d-450f-b8bc-4cad6124b4ff on 06 Jul 2020 00:05:49

RE: Dynamic Constant Line for Targets/Benchmarks

vote+1

James Ward's profile image Profile Picture

96b81f41 a6a1-48dd-b70a-341c480e3347 on 05 Jul 2020 23:39:36

RE: Dynamic Constant Line for Targets/Benchmarks

Vote +1

James Ward's profile image Profile Picture

d149ad42 2b0b-46a8-85bb-051cf5442927 on 05 Jul 2020 23:38:52

RE: Dynamic Constant Line for Targets/Benchmarks

Absolutely a must!

James Ward's profile image Profile Picture

bf5afccb ac4f-4988-84ba-c2db024f4fe6 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

b428278f a4b8-4a0e-81bf-277992cdb2fa 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.

James Ward's profile image Profile Picture

7572f9a8 fdbd-4e29-b2be-129bcecbb2e4 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

725fd120 fdd7-406c-9e5f-15d45e0c077a 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

7733b465 4a1d-4b31-afa2-368500c41530 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.