Average Line using Line and Stacked Column Chart & Trellis chart option in Power BI

[Anonymous]

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

[v-juanli-msft]

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
Maggie

Community 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.

[Anonymous]

Hi,

I tried that before but the value in the average is repeating at every data point as 3.9. I want it to be one time as Average: 3.9. I have used 2 cards and mentioned average and value but that's static when the real average changes card position won't change.

Regards

Harsha

[TomMartens]

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 

[Anonymous]

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?

[TomMartens]

Hey,

the custom visual "Infographic Designer" support some kind of trellis charts.

Regards,

Tom

[Anonymous]

Hey,

Thanks for the sugession.

I tried using Infographic designer chart,I don't see Stacked bar option using Infographics chart and labels on bars.

Is there any workaround to show Stacked bar using infographics and show labels as well?