Totals in column chart / Need suggestion

[vmakhija]

Hello

Here is what I want to do -

Since I cannot show the average bar at the end for Column chart, I am doing a separate graph for the average -

Here although the number for 2nd graph is less, but it still look same as maxium of 1st graph i.e. the scales are not same.

What should be the ideal thing to do here?

Regards

[Anonymous]

Maybe you can find some inspiration in the following post:

https://community.powerbi.com/t5/Desktop/Possible-Analytics-function-dynamic-Total-column-in-chart-w...

If this works then please mark it as the accepted solution.

[Icey]

Hi @vmakhija ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey]

Hi @vmakhija ,

You can change the End of Y axis of the average column chart as the same of the first chart.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vmakhija]

Hi @Icey 

it is not resolved yet.

The solution you suggested to specify "End" as 10 for Y axis is a static solution.

If data changes tomorrow, this will break and End as 10 will no more be relevant.

Regards

[Anonymous]

Hi

The easiest solution would be to add an average line through the 'analytics' pane in the visual.

If this is what you are looking for then please mark it as the accepted solution.

[vmakhija]

I could have added an average line, but it might not be always just the plain average.

Regards

Vicky