Waterfall chart fixed bars position

Question & Answer
, , ,
1

Hi QuickSight Community,

I am working on a waterfall chart and came across some challenges and I was hoping someone could help me.

I would like to set a fixed position for each bar in the chart. This means that I don’t want to sort the bars alphabetically or in ascending/descending order based on their values. I want them to always be in a fixed position. Is that possible? Furthermore, I would like to have the Total bar in the first place instead of the last one. Is it possible to change the position of the Total bar?

Many thanks in advance for your support.

2

Hi @dkrzl
you could define a fix sort order with a calculated field.
grafik

e.g.

ifelse({your_field}="A",2,{your_field}="B",3,{your_field}="C",1,4)

BR

3

Hi @ErikG,

Thank you for your quick reply. This solution helped me!

What about the position of the Total bar? I suppose that this solution is only applicable for all the bars except the Total bar?

Is it possible to somehow change its position and set it as the first bar?

Like this:

image

Thanks!

1 Like
4

Hi @dkrzl
i’m not aware of that function.
BR