Forum Discussion
How to set the conditional formatting colour when the column is text
Original post: Matrix computed row - to show computed columns wit... - Microsoft Fabric Community Hi @v-cgao-msft, I encounter another issue whereby when I want to set the font colour based on va...
Idrissshatila
Super User
Super UserHello emmalim ,
Yes, you can't set the Actual plan as >0 or < 0 because you merged the columns so it is considered text and not number.
it's either you subtract them or sum them to have a number value then you could do a conditional formatting based on what you've mentioned.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Idrissshatila Thanks for your reply. I actually substract 2 measures. Attached the file for your reference. Appreciation your kind support to advice the alternative to show the conditional formatting colour.
BI file:
P&L Sample
