BookmarkSubscribeRSS Feed
Calcite | Level 5

I have a bar graph that uses both a category (School_Name) and a group (School_Category).   If I use just the category (School_Name), I get a graph that look close to what I need, where the school with the most is the tallest bar on the left and things get smaller as you go to the right.  The user wants to color code the bars based on the school category.  I can get the color coding by adding School_Category to the Group role, but then the sort sequence is changed to alphabetic by school name, and the sort option is no longer available.  How do I get the bars to sort in descending Y-Axis order while keeping the color coding benefit of the group column/option.  See attached for examples of what I'm seeing.




SAS Employee

I created this SAS Sample that provides a workaround.






Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

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
  • 1 reply
  • 1 like
  • 2 in conversation