Forum Discussion
Adding Trendline to multi variable x-axis
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
3 Replies
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
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)
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/419643/highlight/false#M192829
