Forum Discussion
brockry1
Helper II
Helper IIConditional 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.
brockry1Helper II
Helper IIFlag = 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.