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 there
Hoping someone can help with this. I have this table (not a matrix table) with the conditional format added:
But when I go to add the traffic light to the Total row as well it turns all the icons (including the Total) to just red.
The traffic light field is a simple DAX measure: Traffic lights = SUM(table[Column1)/ SUM(table[Column2).
Is anyone able to shed some light on why this might be happening?
Solved! Go to Solution.
@Anonymous , In place of Percent use number and use values like .95 to 1
.7 to .95
0 . to .7
Hi @Anonymous ,
Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , as this is % column, Are you using .85 for 85% or 85 .
You should use .85 for 85 %. same is true for others.
else share conditions
Jut tried as suggested and it's the same story. All turn red.
Here's the conditions:
@Anonymous , In place of Percent use number and use values like .95 to 1
.7 to .95
0 . to .7
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.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |