Forum Discussion
Conditional formatting not followed by map bubble?
I have the following conditional formatting ruleset:
When I apply the rule, it doesn't seem to get the 46%-69% rule properly. Spain, China and US should be in yellow but instead are shown in red:
SCORE is formatted as Number type in PQ and as Percentage once loaded:
| ID | Facility Country | SCORE | ||
| 1 | United Kingdom | 86% | ||
| 2 | United States of America | 80% | ||
| 3 | United States of America | 63% | ||
| 4 | Spain | 69% | ||
| 5 | United States of America | 48% | ||
| 6 | United States of America | 58% | ||
| 7 | China | 82% | ||
| 8 | United Kingdom | 72% | ||
| 9 | China | 66% | ||
| 10 | Ireland | 87% | ||
| 11 | United Kingdom | 73% | ||
| 12 | Philippines | 67% | ||
| 13 | Philippines | 98% | ||
| 14 | Philippines | 101% | ||
| 15 | China | 40% | ||
| 16 | China | 79% | ||
| 17 | China | 79% | ||
| 18 | Philippines | 57% | ||
| 19 | United Kingdom | 98% | ||
| 20 | China | 51% |
2 Replies
Hi olimilo,
Could you please try below steps:
To make your map bubbles accept the 46 - 69% rule, switch your conditional formatting thresholds to use decimal fractions (e.g. 0.46–0.69) and treat the field as a Number, not a Percent.
By switching your thresholds to 0.46–0.69 and formatting the column as a Number, Spain, China and the U.S. will now correctly show up in yellow. Just adjust the formatting settings will help to solve.If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X
