Forum Discussion
Column Chart with Dynamic Target line
Dear all, I have a simple table below. The total Value is from the sum of varying products. Year Total Value 2018 100 2019 50 I would like to set a target line based of 9...
mdjoshua94 assuming Total Value is a measure, add the following measure:
Target Line =
CALCULATE ( [Total Value], Table[Year] = 2018 ) * .90
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
I think it works to a certain extend.
When I tried to replicate this for target line against months, I get a zig zag instead of a straight line. Why does the FY becomes 2 consistent value but not the same for the months :(?
