Turn Negative Numbers Red

As of the August 2017 release of Power BI Desktop you can now format your negatives red. It's taken too long and still isn't super easy, but then again it isn't super easy in Excel either.

Here's my article on how to do it in Excel...

Here's how to do it in 2 steps in Power BI

Step 1

Right Click on your value field in my case it's called Data and select Conditional formatting > Font Colour Scales

Step 2

Then set up your window as follows using a Diverging scale -1, 0, 1

Now if only we could add brackets......

Wyn

Access Analytic