Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Categorical, but ordered graph

I have this graph: The numbers aren't in order. How can I do this. When I make it continous, this happens: The x-axis suddently skips every other value. How can I get an ordered axis th...
  • BA_Pete's avatar
    6 years ago

    Hi Anonymous ,

     

    Have you tried selecting the ellipsis at the top right of the chart and changing 'Sort by'? You should be able to change this to the Axis field rather than the Values measure. You can also see below there are Ascending/Descending options to try too.

     

     

    If that doesn't work for you, you may need to add a SortKey field into your source table. 

     

    Pete

     

  • BA_Pete's avatar
    BA_Pete
    6 years ago

    Anonymous 

     

    Try changing the axis back to Categorical then check again please. If not, then you'll probably need a SortKey field.

     

    Pete