Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
JGH1
Frequent Visitor

How to provide average of column data in Card visualisation

Hello,

I'm trying to include a Card visualisation in my dashboard that simply provides the average of a single column of data (see link below). I haven't come across anything that outlines this. Can someone please help me?

Thanks and Regards,

JH

 

https://drive.google.com/file/d/12J9sJQ15hyjEGN98TrO_rEW4TAd4oRFc/view?usp=sharing

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @JGH1 ,

If I understand correctly, you would like to get a average of the field [slump]. If yes, you can apply the field [SLUMP] on the visual with the aggregation function "Average" as below screenshot:

yingyinr_0-1676962977712.png

Or you can create a measure as below to get it, please find the details in the attachment.

Average of slump = AVERAGE('Sheet1'[SLUMP]) 

If the above one is not what you want, please provide more details(special examples, screenshot etc.) to explain your expected result. Thank you.

Best Regards

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @JGH1 ,

If I understand correctly, you would like to get a average of the field [slump]. If yes, you can apply the field [SLUMP] on the visual with the aggregation function "Average" as below screenshot:

yingyinr_0-1676962977712.png

Or you can create a measure as below to get it, please find the details in the attachment.

Average of slump = AVERAGE('Sheet1'[SLUMP]) 

If the above one is not what you want, please provide more details(special examples, screenshot etc.) to explain your expected result. Thank you.

Best Regards

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.