Trendlines on clustered column chart

[ashleyb2022]

Is there a way to add a trendline on this type of chart?  I cant seem to find it anywhere.

I would like to see the trendline move with whichever product line is selected.  For instance, if we are looking at bath lights, we would see the trendline based on the Avg Qty Sold .  Example below along with the Visualization pane.  Thank you!!

[Anonymous · Accepted solution]

HI @ashleyb2022,

The trendlines line is hosted on the analytics panel, please double-check to confirm you are using the general date values instead of the date values with the hierarchy model on the x-axis:

Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

[lbendlin]

You may want to do that in a separate line chart visual. Showing the trend line inside the column chart is inconsistent and likely confusing to your users (how do they know that it is related to a filtered value?

[ashleyb2022]

Thank You!