I have created a vertical 100% stacked bar chart in QuickSight to visualize user application sources over time, with dates on the X-axis and a percentage scale from 0% to 100% on the Y-axis. Each bar represents different application sources such as iPhone, Android, Windows, Macintosh, and iPad, each in distinct colors. Currently, the bars are displayed in the order I’ve set them, but I would like them to be automatically sorted in descending order based on their percentage values. How can I achieve this automatic sorting in QuickSight?
Hello @HarveyB-B , welcome to the Quicksight community!
Have you tried using the sort options in the visual controls on the axis line or via the field well sorting options? More details on this below:
Let me know if this helps!
Same scenario, but different variables. i have apple, banana, cherry, other. the problem is that i need to sort the group/colour via percentage, while maintaining the date being in order. I want it to automatically sort the order, so (in most cases) cherry should be at the bottom, then apple, then other, and banana at the top. i have attached an image to give a better understanding of my problem. as you can see i want the darker blue to be at the top, however without being filtered by %, it is in the middle. Hope this adds more context / easier way to find a solution.
for more context, tmp_100_fruit_stack has this code:
each flag_(fruitname) looks through an order and tells retrieves whether its an apple, cherry, banana, or other. hope this helps !
Hey @HarveyB-B !
I tried a few things on my end and still couldn’t get the visual to sort correctly and is not possible in Quicksight. I will be sure to mark this as a feature request for the Quicksight team to take a look at.