Trend Line for bar chart with categorical X-axis

[Alyona_BI]

Hi, dear PBI experts! 

I need to create the chart in PBI with the following inputs: 

1) This chart should be the combo chart with bars and line. 

2) Bars should be Dates in the format of YearMonths - for example, 2022-Jan, 2022-Feb etc. 

3) Line is trend line based on measure selection. As measures I have 2 metrics: 1) distinct count; 2) simple sum. 

So in the result it should be something like this: 

The problem in PBI is that I can't create the trend line for categorical X-axis in easy way. I surfered for the solution at forum, found several similar ones and implemented it: 

https://community.powerbi.com/t5/Desktop/Add-Trend-Line-to-Column-Chart-with-Categorical-X-Axis/m-p/...

But unfortunately I didn't recieve the correct trend line. The result is: 

Is anyone could help me to deal with this? 

The pbix example with data and formulas you could find here: 

https://drive.google.com/drive/folders/1bfnyBf9LTQEJ3C47DpGouF28r9lncRP8?usp=sharing

Thanks in advance! 

[amitchandak]

@Alyona_BI , You can get a continuous axis with Date and Number, Not with a text column.

so YYYYMM can give you a trend not mmm-yyyy