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. ...
amcd325 what is year_month table looks like in your table? Seems like it is a text. Can you confirm? Also after you created this new measure, did you use it in any of the visuals? If yes, did you get any errors?
I see now that Month Number is an actual option here so I have changed the string to:
IF (MAX( DT_TBL[MTH_NBR] >7, .1)
This string like this works in the file (Thank you!)
I would like to put it in the line graph as either the Y Constant or a secondary Y axis. I'm not sure making it a Y Constant is a possibility, but when I put it in Secondary Y axis field, it makes all of my lines go flat. 😞