Trend Line on Line Chart, Option Does Not Let you change to On

[sarahhaley]

Hello! I am haviong this issue on both the desktop and web versions of PowerBI. I have monthly data I want to show a trend line for, the option shows up under the analysis of the visual, but I cannot turn it to ON, if I try, it just goes back to Off each time.

The data I am showing is a measure I created which is actual a percentage of helpdesk tickets vs those where the SLA was met.

I have a trend line set up for the total incidents and that works:

And the met works as well:

But when I use the DAX to make a percentage of what ones were met, I cannot make this have a trend line.

[sarahhaley · Accepted solution]

To anyone who reads this, I made a new table and used the SummarizeColumns to make totals by the month, then did the percentage calc in the table. Used that field for my line chart and I was able to make a trend line. Woof.

Here was my code for the table

MetSLObyMonth = SUMMARIZECOLUMNS(SLO_Tickets[Year],SLO_Tickets[Month],"Incidents",sum(SLO_Tickets[IncidentCounter]),"MetSLO",sum(SLO_Tickets[MetSloCount]))

Here is my code for the percentage

MetSLOPercent = (MetSLObyMonth[MetSLO]/MetSLObyMonth[Incidents])*100

I still need to figure out how to concat the month/year properly, but this fixed my issue.

(First real report in PowerBI)

[sarahhaley]

I do have this set as continuous. 

[jdbuchanan71]

Make sure your X axis is set to Continuous or it won't let you turn on the trend line.