Waterfall chart with stacked columns

[Anonymous]

Dear All,

I need to create a visualization like this one (with stacked columns):

But there're some limitations regarding the visualization. As you can see there's no option to do it. I already tried to import new visualizations, but the only possibility is not for free. Can you support me to find a solution for this? How can i visualize the draft above?

Thanks!

[v-shex-msft]

Hi @Anonymous,

Did PhilipTreacy 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Shen

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file

If you don't want to/can't pay for a a commercial visual then you are limioted to what is available with the free ones.  With the in-built stacked column you can achieve something like this but it requires manipulating the data - you have to create a 3rd section in the stack to respresent the distance from the x-axis, and then set that to the same colour as the visual background.  This makes it invisible.

You also need to name the other 2 categories in such a way that they are displayed as you want.  By default they are alpahbetically stacked in ascending order from the bottom up.

But you can achieve this

Regards

Phil

[Anonymous]

Hi @PhilipTreacy.

Thanks for your hints, they worked well. Unfortunately there're still some limitations, i will check which one fits more my needs.