Forum Discussion
Hiding negative data labels in Simple Waterfall Chart
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
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
3 Replies
- PhilipTreacy
Super User
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
Thanks PhilipTreacy It did work.
Thanks Nishantjain
- Nishantjain
Continued Contributor
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
