BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
KKJ-dk
Fluorite | Level 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
ShannonMoore
SAS Employee

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

View solution in original post

2 REPLIES 2
ShannonMoore
SAS Employee

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
Fluorite | Level 6

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.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 2548 views
  • 0 likes
  • 2 in conversation