How to set the conditional formatting colour when the column is text

[emmalim]

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 value:
<0, show as red
>0, show as green
But the condition setting determine the column 'Actual - Plan' as Text:

I will need to set as below:

Appreciate your kind support to share the solution, thank you very much!

[parry2k]

@emmalim isn't this what you want?

[emmalim]

@parry2k  I need to applied the colours to column Actual - Plan. But this column is seems like detected as 'text', hence I cannot apply the conditional formatting as per column _Actual 2.
Appreciate your support to share the alternative, thank you very much.  

[parry2k]

@emmalim why -ve is in red and +ve in green, although I think you want it the opposite, no?

[parry2k]

@emmalim is this what you are looking for:

[emmalim]

@parry2k Thanks for your reply. Unfortunately this is not what I'm looking for, sorry for not being precise in the earlier post. The desire result is as per column _Actual 2 below, but i need it to be applied to column Actual - Plan:

BI file:

P&L Sample_v2 

[Idrissshatila]

Hello @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💡

[emmalim]

@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