Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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)

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
2 years ago

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