cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route11 Member
Member

red for negative numbers and stad for positive numbers

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)") 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: red for negative numbers and stad for positive numbers

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

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: red for negative numbers and stad for positive numbers

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

View solution in original post

Route11 Member
Member

Re: red for negative numbers and stad for positive numbers

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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)