Categorical, but ordered graph

[Anonymous]

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.

[BA_Pete · Accepted solution]

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 · Accepted solution]

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]

 Not there.

[BA_Pete · Accepted solution]

@Anonymous 

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

Pete

[Anonymous]

That worked! Thank you very much 🙂

[Anonymous]

This does not appear.