Conditional Formatting on table visual

[phchu1226]

Hi,

I added the conditional formatting for the field GPM% which display red when the % is negative.

However, the background color changed after I clicked another visual in order to show the information of specified order.

Is the conditional formatting just comparing the data shown?

Is there any way to let the negative value still display in red even though just showing one value?

[amitchandak · Accepted solution]

@phchu1226 , No it should still work.

Try to create a measure

if([ GPM%]<0, "Red", "White")

Use that in conditional formatting using the field value option

PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[phchu1226]

Hi @amitchandak ,

Now I am using the field value option rather than gradient, it works. Thanks.