Order stacked bar chart from largest to smallest eje y

Hi @Raulsc, Yes we can achieve this by using Custom Sort in QuickSight.

Please find below where I am trying to replicate your query with my datasets.

Default Sort available in QuickSight

After Custom Sort in QuickSight

For achieving this above solution ,
Step -1
First we need to create one calculated field as,
Custom Sort -Calc and put the serial number for the field data as per requirements.

image

Step -2
Then you go to your default chart that is Horizontal Bar Chart and for getting the manual sort option we need to convert it as Vertical Bar Chart then once we put the custom sort then you can convert again with Horizontal Bar Chart.

Go to x-axis select the Education dropdown then sort by and select Custom Sort - Calc

image

Step -3
Then sort by as the Custom Sort - Cal field & aggregation as Min** and click Apply button.

If you need in more details please go through this solutions.

2 Likes