Forum Discussion
Bar chart formatting negative bars
I have a bar chart where I'd like the negative values to display to the right alongside the positive numbers, while keeping the subtracted total label.
In this visual the light blue is positive while the rest are negative, and while this gives me the correct total label I don't want the negative values shooting off to the left.
I have a second graph that achieves the visual goal, but instead of having the deductions as negative they're positive so the total label incorrectly sums up all the values:
I can include the measures I created, but I wanted to know if this was just a formatting issue that can be easily resolved.
adinny11 - I'm assuming you've used ABS( ) to make the negative values positive, but this creates the problem for the Total label as it is now correctly summing all the positive values.
Unfortunately you cannot use an other measure as a Total label, so what you are looking for cannot be acheived. The original visual is the correct way to display negative values, and by presenting it the 2nd way, you are actually skewing the data and creating a false impression.
I would explain to your viewers why the bars are to the left of the central axis.
2 Replies
adinny11 - I'm assuming you've used ABS( ) to make the negative values positive, but this creates the problem for the Total label as it is now correctly summing all the positive values.
Unfortunately you cannot use an other measure as a Total label, so what you are looking for cannot be acheived. The original visual is the correct way to display negative values, and by presenting it the 2nd way, you are actually skewing the data and creating a false impression.
I would explain to your viewers why the bars are to the left of the central axis.
Great, thanks for the clarification!
