0 Kudos

Color by rules issues

Status: Delivered
by tsapat Regular Visitor on ‎05-19-2018 03:00 AM

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
by Moderator v-yuezhe-msft
‎05-21-2018 12:49 AM - edited ‎05-21-2018 12:55 AM

@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

by tsapat Regular Visitor
on ‎05-22-2018 11:57 PM

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!

by Moderator v-yuezhe-msft
on ‎05-26-2018 11:57 PM

@tsapat,

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

Regards,
Lydia

by Vicky_Song Established Member
on ‎05-27-2018 07:13 PM
Status changed to: Delivered
 
Idea Statuses