I ceated a formula to create a new column and bring back a 1 if the criteria is true and 2 if it is false. I added it to my visual and it worked however when I try to format it using Icons it is not flagging the rule I expected. As you can see it is bringing a 1 if true and 2 if false. I then went into the visual to create a conditional format to flag the "2"s to show a red flag. It did not flag my 2's but is flagging random rows. Am I doing something wrong.

I figured it out. In the rules of the conditional formatting instead of calcuating on sum I changed it to maxium and it is now bringing back what I need.

Conditional Formatting | Microsoft Fabric Community

Forum Discussion

Related content

Conditional Formatting

Condition formatting

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting