Adding Trendline to multi variable x-axis

[vishnuprashanth]

Hi Everyone,

I am trying to add a trendline to the multivariable x-axis in my line chart. If I do it for the date column alone, I am getting the trendline. But if I add my Q_Year(non-date) variable, I am not able to use the trendline. 

Is there any possible way to write a code for the trendline for each half year? 

Below is the Screenshot of my dashboard.

No trendline 

Expected output: I am expecting an output like below, but all the charts merged together. 
all these 4 charts combined together with trend line for each quarters

[v-yulgu-msft]

Hi @vishnuprashanth,

You could refer to this thread providing DAX formula for a trendline.

But the desired output that make four separate charts to be merged together in a single chart is not available right now.

Regards,

Yuliana Gu

[vishnuprashanth]

Hi @v-yulgu-msft,

Thanks for the response. But I wanted to know if it is possible to have multiple trendlines for each quarter, if I use the DAX formula to create a trendline? 

Example:

multi trendline for intervals in x-axis(example done in excel)

[vishnuprashanth]

@v-yulgu-msftBasically, I wanted a trendline or moving the average line for each interval.

I have asked a question with samples here.
http://community.powerbi.com/t5/Desktop/adding-trendline-for-each-time-interval-of-the-x-axis/m-p/41...