Sort Color/Group Field by Measure in Bar Charts

Currently in Quick Sight, when using stacked bar or clustered bar visuals, the Color/Group field (e.g., Dimension such as Country) can only be sorted alphabetically or manually via legend re-ordering.

This limits flexibility when the business requirement is to order stacked/clustered segments dynamically by a measure

Hi @DataPalla

Welcome to the Quick Sight community!

Quick Sight currently limits sorting for Color/Group fields in stacked and clustered bar visuals to alphabetical or manual legend re-ordering, which can be restrictive for dynamic, measure-based segment ordering needs.

One workaround is to create a calculated field that ranks the segments based on the measure, and then concatenate this rank to the dimension label. Refer this community post.

I will mark this as a feature request to promote visibility to the support team.

Hi @DataPalla

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

Hi @DataPalla

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!