Forum Discussion
Solved
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...
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.