Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Waterfall chart with stacked columns

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!

 

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    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

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi PhilipTreacy.

       

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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