cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hxkresl Member
Member

Trendline not available & no forecasting feature in options (may 2017 version)

I have read related posts on topic of Trendlines, and I have a continuous date column on X axis, but trend lines not working on stacked bar chart.

 

What additional requirements need to be satisfied to get the trendlines?

 

 

I am using stacked bar chart and would like to add a predictive trendline (at this point, just because) and I'm not finding the option

Capture.PNG

 

 

and no forecasting option available using Version: 2.46.4732.721 64-bit (May 2017)

Capture1.PNG

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Trendline not available & no forecasting feature in options (may 2017 version)

Hi @hxkresl,

 

From this documenta trend line currently applies to:

  • Non-stacked Line
  • Clustered Column chart

 

In Power BI desktop May release, the forecasting feature is available, but only supports Line chart.

 

So, we could not add a trendline or enable forecasting in a stacked column chart. You could submit this feature request at below page:

https://ideas.powerbi.com/forums/265200-power-bi-ideas?query=multiple%20values%20into%20line%20chart

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hxkresl Member
Member

Re: Trendline not available & no forecasting feature in options (may 2017 version)

@v-yulgu-msft

Yet, a bar chart published to power bi dashboard by another dept has trendlines.  Can you tell by looking at this stacked bar chart what type of trendlines they are?

 

Capture3.PNG

hxkresl Member
Member

Re: Trendline not available & no forecasting feature in options (may 2017 version)

Line and Stacked column chart permit 'Line values'.  

Capture1.PNG

 

@v-yulgu-msft  are line values and trend lines different?

Community Support Team
Community Support Team

Re: Trendline not available & no forecasting feature in options (may 2017 version)

Hi @hxkresl,

 

Yes, line values and trend lines are different. Line values means that adding columns or measures into values section under fields pane to generate a line. Trend line is an option under Analytics pane for some certain chart visuals.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.