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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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