Ordering bars in a bar chart

[CJAY]

Hi there

Brand new user here. I am trying to change the order of bars in a bar chart.  Currently it is sorting by highest count but I want it to sort by year (on the category/x axis). The year is coming from a hieararchy date data item – when I right click on it there is no option to sort. Any ideas?

[Madelyn_SAS]

You should be able to left (not right) click on the name of the hierarchy and see a menu with a Sort option.  If you do not see it, can you send a screen shot of what you do see?

[CJAY]

Hi, when I'm left clicked on the data item, I see a properties box however I am unable to change any of the values in it except for the name.  I've attached a screenshot.  Thanks for your help!

[Madelyn_SAS · Accepted solution]

At the bottom of the bar chart, hover over the Commencement Date Hierarchy until it turns blue. Then, click on it to see the menu with sorting. If right-click does not work, then try left-click.

 

[kaushalsolanki]

Hello Cjay,

After assigning roles in bar chart just go to category value and right click it, It will show you sorting option as you required.

 

Regards,

Kaushal Solanki