Sort Vertical Bar Chart by 'GROUP/COLOR'

Q&A
, , ,
1

Hello,
I found other Questions similar to this, with no solution yet.
The goal is to sort of Visual (Vertical Bar Chart) based on GROUP/COLOR, currently the value are plotted in the chart unordered

image
image1072×594 55.4 KB

Is there a solution or something in roadmap?

Cheers, Giovanni

2

Hi. Thanks you for your question! :slight_smile: Many of our community Experts and folks from our team are on holiday right now. I asked “My Assistant” (universal chat) in Quick Suite, and got this back.
@Brett Could you review and validate the answer below on Monday after you return from holiday?

”Sorting Vertical Bar Charts by Group/Color

…here’s the current situation:

Current Limitation:

In Quick Sight, you cannot directly sort bar charts by the Group/Color field. The sorting functionality is limited to:

  • Fields in the axis (X-axis or Y-axis)

  • Fields in the value field well

You cannot apply aggregation to fields in the Group/Color field well, which means standard sorting options don’t apply to these fields.

Workarounds:

1. Use Color Coding for Better Readability

Instead of sorting by color groups, use color coding strategically to make the chart more readable. You can combine this with action filtering to focus on specific categories.

2. Create a Calculated Field with Custom Sort Order

Create a calculated field that assigns numeric values to your categories, then use this field in the Group/Color field well:

ifelse(
  {category} = 'Category1', 1,
  {category} = 'Category2', 2,
  {category} = 'Category3', 3,
  99
)

Then sort by this calculated field to control the order.

3. Use Field-Based Coloring

The Quick Sight capability in Quick Suite offers field-based coloring that ensures consistency across visuals. While this doesn’t directly sort by color, it maintains consistent color assignments across your visualizations.”

4. Restructure Your Data

Consider restructuring your data so that the grouping dimension becomes part of the axis dimension, allowing you to sort by it directly.”

3

Hi @awsgv,
So it looks like your request is more in reference to order by multiple fields so that when you filter down to a specific period, you have control within each. There is an option to sort by an off-visual field which you could then use your ‘group/color’ field for. However, the only options are count or count distinct for this so that may not help in your scenario.
I’ll mark this as a feature request to promote visibility to the support team. You can keep an eye out for new features as they get released through the ‘What’s New’ Section of the Community.

1 Like