Hiding negative data labels in Simple Waterfall Chart

[SameekshaM]

@MFelix 

@GuyInACube 

@Nishantjain 

Hi,

I am using Simple Waterfall Chart (From Marketplace) to show a breakdown of numbers.

I have achieved the required chart however there is one thing I want to fix.

To show decreases, I've negated the values & the labels appear as -(value) which is not the correct expected output.

The waterfall chart should display the reductions too as positive values. Is There anyway I can do this?

Referring to the above image as a sample,

A,C,H,J & L are marked as pillars. A is the total value. To show decreases, Values for B,D,E,F,G,I,K as highlighted above are negated. Is there any way I can plot the same waterfall chart but just with Label values for B,D,E,F,G,I,K to be shown as positive i.e instead of -100 it should be 100.

Any help on this would be highly appreciated.

Thanks & Regards,

Sameeksha

[Nishantjain]

@SameekshaM currently, there is no built in capability to show the values as absolute. I would suggest you raise a request here

In the mean time, you can use the suggestion from @PhilipTreacy as that should work. Please select "None" in the Label formattaing option

Thanks

Nishant

[PhilipTreacy · Accepted solution]

Hi @SameekshaM 

Download sample PBIX file with this example

Use a Custom Format String to display the negative values as positive

Click on the values column and then in the Format area enter 0;0; and hit Enter

Further reading on Custom Format Strings https://www.myonlinetraininghub.com/custom-formatting-strings-in-power-bi

Regards

Phil

[SameekshaM]

Thanks @PhilipTreacy  It did work. 
Thanks @Nishantjain