DAX

[Sowmiya]

Hi Community,
Assist me in implementation of Trend Line to below visual.
IMAGE 1:



X Axis is Months from Jan 2017 to Dec 2017 , then Jan 2018 to Dec 2018, Jan 2019 to July 2017.
1. X Axis Type is Categorical now. In Categorical Type, Trend line in Analytical pane is not visible.


2. When X- Axis Type is changed to Continous, Trend line in Analytical pane is visible but X-Axis now becomes continous automactically Showing all values from 201701 to 201907 as below.

IMAGE 2:

 But, X-Axis must not be like this because there is no meaningful in showing 201713, 201714, etc,..... (Because there is no month 13, 14)

Help in applying Trend Line to IMAGE 1.

Thanks in advance,
Sowmiya.

[jdbuchanan71 · Accepted solution]

Hello @Sowmiya 

Take a look at this solution from @OwenAuger 

https://community.powerbi.com/t5/Desktop/DAX-to-create-a-Trend-line/td-p/398438

And this article discussing the same solution.

https://xxlbi.com/blog/simple-linear-regression-in-dax/