Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional formatting with only Negative Numbers with different Backcolours

I want to use different backgroundcolours for different RSSI values. (-90 DarkRed)(-60 Yellow) (-50 Green), but it seems negative numbers get only one fixed backgroundcolour as result. How can I solve this? I also tried to make rules, but that doesn't seem to work either.

Results not what I wanted, should have been between yellow and red

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I found the problem thanks to your answer where you mention Sum, I just realised I forgot to make the Column a Integer and it was still a String. I think I overlooked it in the haste.

5 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario.

    Table:

     

    Then you may create a table visual, click 'RSSI' field =>'Conditional formatting'=>'Background color'.

     

    You may choose 'Format by Rules' and set as below.

     

    Result:

     

    Best Regards

    Allan

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      The rules don't work. Could it have to do with the summarization field? Because I don't want to summarize the values. The value is being calculated in the query and isn't a measure that's made in Power BI.

       

      • v-alq-msft's avatar
        v-alq-msft
        Community Support
        6 years ago

        Hi, Anonymous 

         

        I have changed the language to fit your Power BI Desktop. Please set as follows.

         

        Result:

         

        Best Regards

        Allan

         

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

         

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Not able say without looking at data and formula. You can try creating absolute measure and use that for color formatting