Forum Discussion

phchu1226's avatar
phchu1226
Helper IV
4 years ago
Solved

Conditional Formatting on table visual

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?

 

 

  • 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

     

2 Replies

  • 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