Waterfall Chart sort by breakdown field

When I create a waterfall chart (see example below) in Quicksight, the sort order of the breakdown field is by descending order of the values - from largest positive values to largest negative values. In the example below, from 1/1/2022 to 1/2/2022, the sort order of “student” is:

  • AA 9
  • DD -7
  • CC -9
  • EE -20
  • BB -30

Is there a way I can change the sort order to the alphabetic order of “student” field:

  • AA 9
  • BB -30
  • CC -9
  • DD -7
  • EE -20

Hi @Ellie_f
Currently its not possible to give a sort order to the breakdown dimension. I have added feature request in our internal tracker.

1 Like

Hey @Ellie_f - Could you please share the data model as well in order to plot waterfall chart with breakdown?
A tabular structure of data should work for above chart. Thanks.