Conditional Formatting

[brockry1]

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. 

[Anonymous]

Hi @brockry1 

I would like to ask what is the DAX formula for creating a new column?
Could you please provide sample data that would completely cover your problem? A pbix file would be great.(Remove privacy information)

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[brockry1]

Flag = SWITCH(TRUE(),

'Account Data'[Combined Sell-To Number]='Account Data'[Sell_To_Number],1,

2)

The formula is working as far as bring back the true, false statements.  It's when I implement the conditional formatting on the icon when it is not bringing back the flag to the appropriate numbers. 

[lbendlin]

looks like your flag is a calculated column.  Most likely you wanted it to be a measure.

[brockry1]

The column is bringing back the correct true, false conditions.  Where I ran into an issue was with the conditional formatting using hte icon and it is not showing a flag on the 2's like it should.  

[brockry1 · Accepted solution]

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. 

[Anonymous]

Hi @brockry1 

I am happy to learn that you found the cause of the problem and fixed it.

Please accept your own reply as a solution, it will make it easier for other users who may be experiencing the same problem to find a solution.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.