Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Trend Line Not Available Workaround

Good Morning,   I have a line chart that I would like to have a trendline added to. Unfortunately to get the data to populate in the correct chronological order I had to change the data type from c...
Need Help
  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    Hi Anonymous ,

     

    Unfortunately, if thex axis is type Categorical, you won't get the trend option.

    But you can refer this case below, it taked a solution to producing a trend line for a scatter chart is to use DAX or R, or a custom visual.

    Solved: Trend Lines! - Microsoft Power BI Community

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yinliw-msft's avatar
v-yinliw-msft
Community Support
3 years ago

Hi Anonymous ,

 

Unfortunately, if thex axis is type Categorical, you won't get the trend option.

But you can refer this case below, it taked a solution to producing a trend line for a scatter chart is to use DAX or R, or a custom visual.

Solved: Trend Lines! - Microsoft Power BI Community

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.