Search code examples
powerbidaxdata-analysispowerbi-desktopconditional-formatting

Apply conditional formating on Table Visualization - Power BI


Trying to apply conditional formatting on Table Visualization in Power BI I received a warning to check the logic of my rule. The logic I want to apply is simple, if the value is 0, set a tick else set a cross.

Find below the warning received:

enter image description here.

Update based on @davidebacci answer:

enter image description here


Solution

  • How can the number be both greater than zero and less than zero at the same time? You have contradictory logic in your branch.

    Try this:

    Add a third rule. In your second existing rule, type 9e9 in the fifth box. In your third rule, type > -9e9 < 0. You can add a cross icon for this branch too.