Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

conditional formatting probs

hi,   i have been trying to color my (line & clustered column) chart with conditional formatting based on the following settings:   where i wish to have green color for +ve valued columns &...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    I've had the same problem couple weeks ago. When i copied a visual and edited it it did not work, but when i remade the visual from scratch the logic did work. 

    Hope this helps you out.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

i think such behaviour is a consiquence of grey words "minimum" and "maximum" usage in first screenshots

It is the only hints, not exactly minimum and maximum values. You should point exact values in conditions

Also, "percent" is default unit for conditional formatting.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    tks for your response too, az38.

     

    can you kindly advise what exact values should i put in there instead to get red as i have tried it (using '0') without success many times earlier?

     

    krgds, -nik