Forum Discussion
vishnuprashanth
Helper III
Helper IIIAdding 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) variabl...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi 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
vishnuprashanthHelper III
Helper IIIHi 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/419643/highlight/false#M192829