Removing Negative Signs for Bar Chart

[#1]

Hi,

I have created a stacked bar chart with two different sales types (used expression not dimensions). I have used negative sales to divide the sales by origin. Now I want remove negative sign from the texts. Is it possible. For example. Instead of -1385 I want 1385

[sunny_talwar]

May be like this:

Dual(Fabs(YourCurrentExpression), YourCurrentExpression)

Replace YourCurrentExpression placeholder with whatever your expression you are using today.

[stigchel · Accepted solution]

Yes you can change the format pattern for that expression in the Number Tab of the chart properties to

#,##0%;#,##0%

[#4]

Yes! works! Thanks