Hi Team,
I am new to power bi.
How to change "0" value with "<1" using DAX. and datatype also must be with "whole number" like below snapshot.
Kindly please suggest with snapshot?
1 ACCEPTED SOLUTION
@Ayyappa5678 Use a Custom Format String like this: 0;-0;"<1"
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@Ayyappa5678 Use a Custom Format String like this: 0;-0;"<1"
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
