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 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.

 

 

 

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)

     

3 Replies

  • 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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I do have this set as continuous. 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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)