Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have the following measure which is just a check to see if information has been recorded...
Costs = IF('Contract Manager'[TotalLabour] = 0, "N", "Y")
This obviously shows Y or N on the table / matrix. Using conditional formatting is it possible to replace Y or N with an X or tick from the icons?
Solved! Go to Solution.
Hi,
You could use conditional formatting like the example below
You could also use UNICHAR() instead of N/Y in your measure as shown below
Costs = IF('Contract Manager'[TotalLabour] = 0, UNICHAR(10006), UNICHAR(10133))
Hi @sanderson82
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sanderson82
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
You could use conditional formatting like the example below
You could also use UNICHAR() instead of N/Y in your measure as shown below
Costs = IF('Contract Manager'[TotalLabour] = 0, UNICHAR(10006), UNICHAR(10133))
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |