Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Clustered Column Bar Graph - Analytics Tab - Calculating Avg. on Avg.

Hello everybody :) I was requested to create a new dashboard in Power BI to show the average Customer Satisfaction Index (CSI - 1 to 10) per Brand and Salesperson. The idea is to have one graph for ...

Need Help

v-eachen-msft
7 years ago
Hi Anonymous ,

You can create a new column to calculate average. The aim of it is to make the average sources consistent.

AVG = CALCULATE ( AVERAGE ( 'Table'[CSI] ), ALLEXCEPT ( 'Table', 'Table'[Band], 'Table'[Person] ) )

Then you need to use line and clustered column chart, put the “AVG” to the “line value”.

Best Regards,

Eads

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

Anonymous

Not applicable

7 years ago

Hello Eads,

Thank you very much for your help.

Unfortunately this solution creates a problem in the visual.

Bellow is a picture of the reulting Graph (I replaced the name of the salesperson with the location of the store so that there wouldn't be a problem uploading the image).

Despite the value being the same (I checked the decimal places, the values are exactly the same) the line fluctuates, I have already seen some users reporting this issue and I believe Power BI team is already trying to solve the situation.

I will keep checking for an alternate solution and post it here for other users, if by any chance you have another sugstion please let me know.

Either way thank you very much for your help :)