BookmarkSubscribeRSS Feed
lelkins4
Calcite | Level 5

This feels like a simple problem to have but I just can't figure it out if it is even possible. I would like for my bar graph to display the breakdown of concentrations (sub category of majors) upon selecting a major from my drop down menu. I have a drill down hierarchy also set up and that is great and works, but I would like even more for those concentrations to be listed upon major selection as stated before. Any suggestions? Screenshot 2026-03-10 170547.png

3 REPLIES 3
tsukune
SAS Employee

You can use Lattice rows which creates a lattice of charts with a row for each value of the category data item that you assign.

 

Here is a sample output:

Bar_Chart1.png

 

For more information, please refer to Data Roles for a Bar Chart, Working with Bar Charts

I hope it helps you.

 

lelkins4
Calcite | Level 5

This would be great if the default view (no major selected) wasn't so messy.

 

Screenshot 2026-03-11 084629.png

 

I know it would work great if there were not so many majors to display, but I guess it can't be avoided. Is there a way for me to display majors more like this while still having the nice concentration breakdown after selecting a major (like my original look below)? 

 

Screenshot 2026-03-11 0846293.png

NithinRamu
SAS Employee

Hi, in the Data Roles pane on the right, try assigning submajor to the Group role. Depending on what you want to display In the Options pane, (ensure the bar chart is selected in the drop-down menu at the top) you can then change the grouping style to Stacked and/or Normalise bars to 100% if you want to look at proportions within groups.

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore 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
  • 3 replies
  • 465 views
  • 0 likes
  • 3 in conversation