Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-yuta-msft
Community Support
Community Support

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
v-yuta-msft
Community Support
Community Support

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
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.