Datatable - Values Negative - Show Positive - Stacked Column Chaart

[sjoerdbuis]

Hi I have a datatable showing negative values.

In my Stacked Column Chart I want to show them as positive values, any suggestions?

I do not want to add a column referring to the column making the amounts positive.

[CheenuSing · Accepted solution]

Hi @sjoerdbuis 

Have you tried using ABS(yourtable[ColumnName]) ?

ABS funtion will convert the negative numbers to postive numbers.

I am a bit curious to know any specific business rule or scenario that you want to show the negative values as positive in the stacked column chart.

Cheers

CheenuSing