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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
lhookway
Regular Visitor

conditionally format table value for a total using another value

Hi all, 

I need to format the Employed number in this table to show if the number is < 5 that it shows < 5 and not the actual number.  

Employer Name                                              Employed                 Employed needs to be shown as

ABC Company                                                   3                                  <5

A.B.C. Chidcare & Developmental Center         1                                  <5

Amazon                                                            26                                  26

Google                                                               4                                  <5

Yelp!                                                                   2                                  <5

 

Is this possible and if so, how? 

 

Thanks in advance for your help!

 

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @lhookway 


What you could do, is to create a new measure which would create the values you need for example below.

 

I have assumed that you have a measure already called [Employed]

 

Less than 5 =
VAR LessThanFive = IF([Employed] < 5, "<5", [Employed])
RETURN
LessThanFive 

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

Try like below. In case you face data type issue

Less than 5  Employee=
VAR _LT5 = IF([Employed] < 5, "<5", [Employed] & "")
RETURN
_LT5 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
GilbertQ
Super User
Super User

Hi @lhookway 


What you could do, is to create a new measure which would create the values you need for example below.

 

I have assumed that you have a measure already called [Employed]

 

Less than 5 =
VAR LessThanFive = IF([Employed] < 5, "<5", [Employed])
RETURN
LessThanFive 

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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