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 There
Looking for some help please.
I have a table where the values are -1, 1 and 0.
In conditional formatting I want it to to show the following
-1 to show a 'X' symbol
1 to show a Tick symbol
0 to show text N/A
I can do conditional formatting for the cross and tick but cannot get the word N/A to show in the cells where there is a 0.
I've tried the below which works for the symbols and ive also tried doing in Cell Elements (icons)
Solved! Go to Solution.
Hi @KarenFingerhut ,
Please refer to my pbix file to see if it helps you.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Polly
So sorry for late reply. I did resolve this by adding in a table with
And then did the following DAX
Once again thanks for your reply.
Kind regards
Karen
Hi @KarenFingerhut ,
Please refer to my pbix file to see if it helps you.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Polly
So sorry for late reply. I did resolve this by adding in a table with
And then did the following DAX
Once again thanks for your reply.
Kind regards
Karen
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
71 | |
67 | |
51 | |
39 | |
26 |
User | Count |
---|---|
87 | |
54 | |
45 | |
40 | |
36 |