Forum Discussion

Velvetine27's avatar
Velvetine27
Helper I
3 years ago

Absolute values displaying original value

Hi all,

 

I have a column full of negative and positive values. I need to create a visual that displays every bars upright, including the negative values and I need to display the data labels too. My only solution is to create a new column of absolute values which I then set conditional formating to change the color of bars depends of negative/positive. Is there a way I can make the data labels to display the negative signs for red bars ? Thanks !