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 sorry to ask, but how would I apply this? I've tried putting it in a bunch of the fields, but keep getting an error. Maybe I did the measure wrong - I did get it created successfully doing it this way. I haven't gotten to the DAX part of my training yet lol. I appreciate your help and patience.
Template:
Trend Line Measure =
IF ( MAX ( Table[Month Number ) > 8, .1, .2 )
Our Info:
Y-Axis Constant Line Measure =
IF (MAX(DT_TBL[Year_Month]) > 7, .1)