Color Text

[WaelTalaat79]

Dears,
i have this DAX formula and it shows as text because it contains % and Value in the same column

I need to color in read the text in negative

Margin Gap =

Var _MarginPercent = (DIVIDE([Margin Value],SUM('Sales'[Tot Sales])))

Var _MarginContract = MAX('Contract details'[Margin %])

Var _Marginvalue = (SUM('Sales'[Tot Sales]))-(SUM('Value'[Purchases]))

Var _MarginQTY = (_Marginvalue)/SUM('Value'[Invoice Qty])

VAR _Supplier = MAX('Value'[Supp.# & Name])

return

((IFERROR((IF(_Supplier="5927 MAHMOOD MALLIK INTERNATIONAL G.T", ((_MarginQTY)-(_MarginContract)),IF(_Supplier="6784 JUST FRIENDS CATERING SERVICES", ((_MarginQTY)-(_MarginContract)), FORMAT((_MarginPercent- _MarginContract), "0.##%")))),0)))

[WaelTalaat79]

Thanks

[v-xinruzhu-msft · Accepted solution]

Hi @WaelTalaat79 

You can create a measure to format.

Format = IF(CONTAINSSTRING([Margin Gap],"-"),"red","green")

Then put it to the conditional formatting of the [Margin Gap] measure, select font color.

Then set the condition.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.