Hello team, I want to remove the decimal places from a measure. For ex. If value is 4.00 I want to display it as 4.
I have used below dax fir it. But not working.
Avg days = trunc(avg(orders[delivery days]))
Please help
Hi,
The amount of decimals displayed is a formatting setting. Check how many decimals you have here (in my example I have 0):
If you want to change this with dax use FORMAT function e.g. FORMAT([measure],"#")
This will display your number with 0 decimals.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Hi,
The amount of decimals displayed is a formatting setting. Check how many decimals you have here (in my example I have 0):
If you want to change this with dax use FORMAT function e.g. FORMAT([measure],"#")
This will display your number with 0 decimals.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
