red for negative numbers and stad for positive numbers

[Anonymous]

Hi Experts (note i am using a live connection in power bi and conditonal formating option is out)

How would you amend the current measure using HEX Code or an alternative method to show negative number as red and postive as standard colour.

Measure:

$NSvPY4% (NOE @ AOP Rate) = FORMAT([Net Sales @ AOP Rate BM - NOE]-[Budget Sales BM Reported AOP],"#,##0.0);(#,##0.0)") 

[v-yuta-msft · Accepted solution]

Hi Route11,

So your requirement is to achieve different color based on condition, right? Please refer to link below:

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting.

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy

becasue this is a "(note i am using a live connection in power bi and conditonal formating option is out)"

i cannot use that link or method, need a work around.