Conditional formatting with only Negative Numbers with different Backcolours

[Anonymous]

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

[v-alq-msft]

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]

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]

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.

[Anonymous · Accepted solution]

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.

[amitchandak]

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