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 90% of 2018 Value accross both columns which can then adapt based on the filtered product.
3 Replies
mdjoshua94 assuming Total Value is a measure, add the following measure:
Target Line = CALCULATE ( [Total Value], Table[Year] = 2018 ) * .90Check 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 :(?
mdjoshua94 It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.
