Solved: Stacked Bar Chart where negative values are subtra...

Anonymous · ‎01-07-2020

Hi everyone,

Hopefully someone can help me out with my issue here, I have 2 values - one is a total and one is an adjustment to the total

For example I have 158k as my total and -15k as my adjustment, when I do a stacked bar in PowerBI I get this, which makes sense.

Is there any way to have the adjustment amount stack on top of the total? I did this quickly in excel to get an idea

I know I can do a couple different measures to get the positive adjustment and then the difference between the total and adjustment and stack those measures up instead, but I was hoping there would be an easier way? Also the adjustment isn't always negative. I've looked at bullet graphs but can't seem to get it exactly right.

Thanks for any help you can provide!

Ashish_Mathur · ‎01-07-2020

Hi,

You will have to write 2 measures to solve this problem.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

ebartlet123 · ‎03-25-2021

Can you explain further?

v-chuncz-msft · ‎01-08-2020

@Anonymous

You might take a look at Create and use waterfall charts.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.