Forum Discussion
Average Line using Line and Stacked Column Chart & Trellis chart option in Power BI
Hi,
I am working on Sportfire to Power BI migration project where I could see bit challenges interms of average lines/trellis chart option in Power BI, which Sportfire/Tableau could do those.
Is it possible to use Average line from analytics tab for Line & Stacked columns chart?
I could see analytics is enabled only for clustered column & clustered bar chart so far. (for bar chart related).
I have a requrement to show average line for Line & Stacked column chart. Is there a chance that this feature is going
to be enabled in next releases?
please respond to me with appropriate workaround or Update for next release.
Regards
Harsha Vardhan
6 Replies
Hey,
I'm not aware if this will be coming with one of the next updates of Power BI Desktop.
A workaround could be to create a measure that calculates the avarage of the stacked segments, then this measure can be used for the line chart.
Regards,
Tom
Hi,
I have created average for the stacked segment and used in Line values which shows avg value in every data point repitetively and in secondary axis I had turned show values off. The average line is pops up but with not proper label.
At the same time I should show totals on Stacked bar, for this again i should use same measure in line values and made stroke width under Shapes as 0. This is causing hiding avg line but labels are repeating.
@Trellis chart: Any chart in Power BI satisfies Trellis chart requirements?
Hey,
the custom visual "Infographic Designer" support some kind of trellis charts.
Regards,
Tom
Hi Anonymous
Please look at my workaround.
Add two measures in the line field,
change the stroke width for "total" measure to 0 under Shapes.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
