Forum Discussion
Stepped Trend Line - Is it possible?
Is there anyway to make a "Trend" line or a "Y-Axis Constant" line into a stepped line? I have a request to have the trend line sit at 20% until a specific month and then drop to 10% moving forward. ...
parry2k
Super User
Super Useramcd325 create a measure for the trend line, tweak the logic as you see fit.
Trend Line Measure =
IF ( MAX ( Table[Month Number ) > 8, .1, .2 )
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.