Forum Discussion
Showing Average instead of Total
I see when you turn on Totals you can see the totals of the columns. Any way to see the average of the columns instead by any chance? I don't want to show it in a seperate table.
Hi Anonymous ,
Please right click on your value fields and choose aggregate mode 'average', then powerbi will display average result on total level.
Work with aggregates (sum, average, and so on) in the Power BI service
Regards,
Xiaoxin Sheng
Hi Anonymous ,
Please right click on your value fields and choose aggregate mode 'average', then powerbi will display average result on total level.
Work with aggregates (sum, average, and so on) in the Power BI service
Regards,
Xiaoxin Sheng