Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
Try like below. In case you face data type issue
Less than 5 Employee=
VAR _LT5 = IF([Employed] < 5, "<5", [Employed] & "")
RETURN
_LT5
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.