Reply
Member
Posts: 99
Registered: ‎12-07-2015

Conditional formatting background colors different on same value

[ Edited ]

I'm running the July 2018 issue of Power BI and the conditional formatting color settings seem buggy. I've run several different scenarios and the colors Power BI assigns are inconsistent. Here's what I'm finding:

 

  • The same number brings in different colors:

 

issue_1.png

 

 

 

  • The system doesn't "obey" the number rules set and there's little to no differentation in the colors assigned to different numbers:

issue_2.png

 

 

  • Removing the numbers (0,2,4) in the min/center/max settings makes it worse:

 issue_3.png

 

 

 

I'm curious to know if others have encountered this.

 

Thanks,

Jonathan  

Highlighted
Member
Posts: 99
Registered: ‎12-07-2015

Re: Conditional formatting background colors different on same value

To make this stranger, I'm wondering if the order of operations and the fields selected before/after the conditional formatting makes a difference (which doesn't make much sense). But here's an example where the fields and conditional formatting settings are the exact same, but with a different result (the left one, correct).

 

issue_4.png

 

Odd.

 

Jonathan

Community Support Team
Posts: 1,116
Registered: ‎07-25-2018

Re: Conditional formatting background colors different on same value

[ Edited ]

Hi @jschlereth

 

You may check if the summarization of values match the summarization in conditional formatting. 

 

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.