cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sjoerdbuis Frequent Visitor
Frequent Visitor

Datatable - Values Negative - Show Positive - Stacked Column Chaart

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.

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Datatable - Values Negative - Show Positive - Stacked Column Chaart

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
1 REPLY 1
Super User
Super User

Re: Datatable - Values Negative - Show Positive - Stacked Column Chaart

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!