topic Trendlines on clustered column chart in DAX Commands and Tips

Trendlines on clustered column chart

ashleyb2022 — Fri, 14 Oct 2022 02:05:24 GMT

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!!

Re: Trendlines on clustered column chart

lbendlin — Sun, 16 Oct 2022 18:52:40 GMT

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?

Re: Trendlines on clustered column chart

Anonymous — Tue, 18 Oct 2022 02:03:20 GMT

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

Re: Trendlines on clustered column chart

ashleyb2022 — Tue, 18 Oct 2022 18:27:47 GMT

Thank You!