Spreadsheet-style format code to show both numbers in Millions and Percentages

8575bf23-a4ce-42ca-9f68-823ee23b9ebb.png

In the chart above, I am trying to visualise absolute numbers in Millions and MoM% change in percentages. 

In the data table there are negative MoM changes, which however are not shown with a negative sign in the visualisation. 

The spreadsheet style formatting code I am using is the following:

[<100]0%;[<999950]0,"K";[<999950000]0.0,,"M";0.0,,,"B"

I can’t get past this last little issue with negative percentages. 

Would be glad to anyone who could step in and help out!

2 0 1,420
0 REPLIES 0
Top Labels in this Space
Top Solution Authors