topic Re: Conditional Formatting in DAX Commands and Tips

Conditional Formatting

brockry1 — Fri, 13 Dec 2024 20:02:34 GMT

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.

Re: Conditional Formatting

lbendlin — Sat, 14 Dec 2024 00:50:41 GMT

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

Re: Conditional Formatting

Anonymous — Mon, 16 Dec 2024 02:33:00 GMT

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.

Re: Conditional Formatting

brockry1 — Mon, 16 Dec 2024 14:56:04 GMT

Flag = SWITCH(TRUE(),

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

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.

Re: Conditional Formatting

brockry1 — Mon, 16 Dec 2024 15:00:01 GMT

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.

Re: Conditional Formatting

brockry1 — Mon, 16 Dec 2024 15:11:41 GMT

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.

Re: Conditional Formatting

Anonymous — Tue, 17 Dec 2024 00:56:03 GMT

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.