Forum Discussion
Sorting the x-ax by number
Hello all,
I have a problem with sorting the x-ax of my graph.
See the screenshot.
The 10 is between the 1 and the 2, however, I need the 10 to be after the 9.
Can anyone help me with this problem?
Thanks in advance!
Regards,
Cornee
Anonymous you can add a number column let's call it "sort answer" for each corresponding answer and sort your existing answer column with this new "sort answer" column in modelling tab. It will give you the result you are looking for.
6 Replies
- parry2k
Super User
Anonymous seems like the column you are using on x-axis is of type string, change its data type whole number and it will work.
Thanks for your response parry2k.
However, it does not seem to be possible to change this data type.
Could this be the case when the data is uploaded in PowerBI by an self made API?
The data is extracted from a website with several questionaires. A single questionaire has several kind of "data-type" answers: text and numbers.
- parry2k
Anonymous are you saying that column you currently have on x-axis does also contains text for example like this.
1
2
3
10
11
Yes
No