Forum Discussion

olimilo's avatar
olimilo
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

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 i...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi olimilo 
    Modify formating option to Decimal Fraction like 0.75 ,1 etc...  instead of percent , and celect "Number" instead of "Percent"
    it should work.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
1 year ago

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