Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

Color by rules issues

When using the "Color by rules" functionality in PBI Desktop, the application permits only the "AND" clause, and also it does not provide negative logic (is not) operators.

 

For example, if I wanted to apply a rule to set the font color of cells that have non-zero values to a specific color, there is no way to do that, as you see in the screenshot below:

 

PBI-Issue-colorbyrules.PNG

 

Is there a fix on the way or a workaround to this issue?

Status: Delivered
Comments
v-yuezhe-msft
Employee

@tsapat,

You can configure conditional formatting  as shown in the following example. Also you can set a larger value(e.g 100000) instead of the max positive value after "is less than or equal to", or set a smaller value(e.g -10000) instead of min negative value after "is greater  than or equal to".
1.PNG

Regards,
Lydia

tsapat
Advocate I

Thank you @v-yuezhe-msft for the workaround.

 

Still I think that the rules should be a bit more "logical", like the Conditional Formatting in Excel.

 

Thanks!

v-yuezhe-msft
Employee

@tsapat,

You can submit a feature request in Power BI ideas forum.
https://ideas.powerbi.com/forums/265200

Regards,
Lydia

Vicky_Song
Impactful Individual
Status changed to: Delivered