Adding Trend line by using DAX

[me418]

Hi,

I really want to add Trend lines here using DAX , the same as using TREND function in Excel.

I'm very new to DAX, would you please let me know how to write DAX formula to add trend line?

Thank you. 

[amitchandak]

@me418 , Thre dotted lines?

You can add a constant lines from the analytics pane.

In the newer version, you can use a measure in that

[me418]

Hi,

Thank you for your suggestions.

After updating Power BI version, I can see Constant line under Analytics menu,

But it's constant line which is different what I need. 

I need to add Trend line in this visual like in Excel.

Do you know if it's possible to add Trend line although the data format is not date? 

[v-rzhou-msft]

Hi @me418 

I think you want to create a trend line by dax like in excel. 

Here I find a post with same requirement like yours, and I hope it could help you.

For reference: DAX to create a Trend line?

Best Regards,
Rico Zhou

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