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!