Forum Discussion
Conditional Formatting
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.
6 Replies
looks like your flag is a calculated column. Most likely you wanted it to be a measure.
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.
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.
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.- 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.
