Absolute values displaying original value

[Velvetine27]

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 !

[johnt75]

I think you could use the technique described in https://www.sqlbi.com/tv/displaying-measures-as-percentages-in-power-bi-charts-unplugged/