Forum Discussion
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 that does not skip a value? Thanks.
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
Anonymous
Try changing the axis back to Categorical then check again please. If not, then you'll probably need a SortKey field.
Pete
5 Replies
- BA_Pete
Super User
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
Anonymous
Try changing the axis back to Categorical then check again please. If not, then you'll probably need a SortKey field.
Pete