Sorting bars in a bar chart

[KKJ-dk]

Hi all

I have a variable, e.g. profit, and three categories in a bar chart: x, y and z. Right now the categories are sorted decending resulting in the order x y z.

I have linked it with a regional map, such that when you click a region the bar chart shows the information for the given region. The problem is that the since profits are different across regions the categories shuffle, so now it may be z x y or x z y.

Is there a way to maintain the orginal order when looking at different regions. So that I always have x y z even if y has the highest profit?

Thanks in advance
Kasper

[ShannonMoore · Accepted solution]

Kasper, Have you tried a custom sort on the category - X Y Z?  I was able to create a report in the Visual Analytics Designer that had a regional map with a section link to a Bar Chart.  My testing showed that that when changing regions (cities in my case) the bar chart honored the custom sort since it is not based on values. Shannon

[KKJ-dk]

Thank you Shannon, it worked.

I had apparently not specified whether the bar chart should be sorted ascending or descending, but once I did that it honored the custom sort.