Visualizations: Category Axis Order

  • 2
  • Question
  • Updated 2 years ago
  • Answered
Is it possible to arrange the category axis of a column chart so that the values are sorted alphabetically? I am using a text field for category axis and the order is completely random. Would love to have them display/sort alphabetically. Thanks!
Photo of Ryan Schowalter

Ryan Schowalter

  • 136 Points 100 badge 2x thumb

Posted 4 years ago

  • 2
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Apply a default order in your model.  (Advanced tab of the model properties).  This will affect the order of the categories in the chart. 
Photo of Ryan Schowalter

Ryan Schowalter

  • 136 Points 100 badge 2x thumb
Awesome, thanks for the help!
Thanks for this -- I am running into the same issue. For whatever reason, though, I'm not seeing the option to apply a default tab in the advanced tab of the model properties. Am I looking in the wrong place or overlooking something?

Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Ha.  We've changed the layout of the Model properties in the last year.  Now default order is on the basic tab.  Look for "Fields to order records by" ...
Photo of Ben Knecht

Ben Knecht

  • 946 Points 500 badge 2x thumb
Hi Everyone,

In the "field to order records by", is it possible to choose a field (i.e StageName), and then choose a specific order for those values?

Use Case: I have a column chart on opportunities with the category axis as StageName, but I need to apply a specific order to them (not alphabetically by their StageName). Is this possible? 

Thank you!
(Edited)
Photo of Derell Jenkins

Derell Jenkins

  • 62 Points
Hi Rob,

I have a chart that has a defined "Fields to order records by" value. The Category Axis shows months of the year. The X axis typically shows each month in the correct order, but if a record does not exist for a given month the months are shown in a random order. 

For example:

Here is a view of what happens when a record exist for each month.


Here is a view of what happens when a record DOES NOT exist for a given month.



Any thoughts?

Thanks,

Derell