Bar Chart Sorting - Alternative Dimensions

[Coldie]

Hello guys,

I haven't been able to figure out how to custom sort a bar chart when using alternative dimensions.

In the example file I have three dimensions in a bar chart.

1. Due Range Description
2. Customer Name
3. Country

I would like the "Due Range Description" dimension use a custom sort based on the DueRange field (ascending order). The Customer Name and Country dimensions should be sorted by Invoice Amount (descending order). When I fix the "Due Range Description" sort and select Customer or Country and change their sorting, the Due Range reverts to sorting by in invoice amount.

Several posts suggest this should be possible, but I haven't been able to get it to work. So, is i possible and, if so, what am I doing wrong?

I use QS (February 2022 Patch 3).

TIA

[rubenmarin · Accepted solution]

Hi, you have to select each dimension to configure it's own sort order, in the attached file Due Range is sorted by range, the other two are sorted by descending Sum(Amount)

[Coldie]

Thanks, it's working now.