Forum Discussion
Helper IChart - Keep numerical category data in ascending order
Hi hoping you can help.
I have an x-axis of section categories represented by a number. On my chart I want to show the categories in a consistent ascending order. However, currently the categories change depending on the Y-Axis score.
I would like to keep the x-axis constant regardless of the score changing. WOuld also like to get rid of the light grey/blue on the first y-axis that is basically reflecting the line chart of the secondary y-axis.
Is it possible to keep categorical x-axis data constant?
Isn't section the name of your category? It isn't selected.
4 Replies
- danextian
Super User
HankScorpio2It only allows sorting by the y categories.
- danextian
Isn't section the name of your category? It isn't selected.
Hi HankScorpio2 ,
Thanks for your time.
Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.
If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.By the way, we can also troubleshotting by below steps:
Duplicate a visual out, and then change the duplicated visual to a table visual.
In the table visual, check the field of x-axis if it can be sorted correctly. Sometimes, the sort is wrong because there may be a problem with the field itself.
Best Regards,Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
