Forum Discussion
Trendlines on clustered column chart
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!!
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
3 Replies
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?
Thank You!
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
