Forum Discussion

rbreneman's avatar
rbreneman
Helper II
5 years ago
Solved

Conditional Formatting with percent not working as expected

Hi! I'm having trouble getting conditional formatting on a matrix visual working the way I want. I feel like this is harder than it should be. Screenshot below shows the rules I have in place. Basic...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey rbreneman ,

     

    with the dialogue you cannot round numbers like when it'r rounded 0 it should be black.

    For that you would have to use a measure.

     

    Otherwise you can do it with numbers and remove the number to also format correctly for the Maximum/Minimum. In your case number above 100% wouldn't get a color:

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
rbreneman's avatar
rbreneman
Helper II
5 years ago

Thanks everyone! Kinda figured I might have to use a measure to get exactly what I wanted, but wasn't entirely sure. I appreciate all the help you provided.