Forum Discussion
Gauge Target Line Increase Weekly
How can I create a gauge target line that dynamically increases each week by the same increment? Is there any DAX that can do this so that I am not manually setting it each week?
I would like my gauge to represent the following:
Min = 0
YTD target = builds by 4 every week
Max = 198 (4 x 52 – 2.5 vacation weeks)
Thank you!
S_Berg try this:
Target Measure = 4 * ( WEEKNUM ( TODAY() ) - 2.5 )Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions 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.⚡
2 Replies
S_Berg try this:
Target Measure = 4 * ( WEEKNUM ( TODAY() ) - 2.5 )Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions 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.⚡
Great! Thank you so much for your help!
