The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
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:
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
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:
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
User | Count |
---|---|
86 | |
85 | |
35 | |
35 | |
34 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |