Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi! I'm fairly new to using Power BI. So I downloaded this data set from kaggle: https://www.kaggle.com/datasets/krishd123/olympics-legacy-1896-2020 , and i am trying to show average age for each individual year. I've tried creating a measure using this:
It would be more accurate to round the result of the AVERAGE function to the nearest whole number?
I've tried this way too using this measure:
Solved! Go to Solution.
when you select your measure, at top toolbar, there is an option Measure Tools then change the Format of the measure to whole number from there ( by default General appears)
when you select your measure, at top toolbar, there is an option Measure Tools then change the Format of the measure to whole number from there ( by default General appears)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |