Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
User | Count |
---|---|
21 | |
16 | |
15 | |
15 | |
12 |
User | Count |
---|---|
42 | |
25 | |
22 | |
18 | |
11 |