cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kaimoon31 Frequent Visitor
Frequent Visitor

Re-Ordering the x-axis of column chart

Hello,

 

As you can see the images below, i tried to re-order as the order below:

- 0~ 500; 500~1000; 1000~1500; 1500~2000; 2000~2500; Over 2500

 

However, I stuck at 500~1000. I tried to look for the solution on internet but it cannot help me.

Does anyone have any solution for it?

Capture1.PNGCapture2.PNGCapture3.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Re-Ordering the x-axis of column chart

@kaimoon31 it is very common problem, you need to add aother column SalaryRangeSort in you model with similar if condition but instead give it a number,  replacce "0-500" with 1, "500-1000" with 2 and so forth so on...

 

once you have new column added, go to modelling tab, select salary range column and in sort by drop down, select salaryrangesort

 

here is example image from my sample dataset

 

image.png

 

 

That's it, it will fix the issue.

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




1 REPLY 1
Super User
Super User

Re: Re-Ordering the x-axis of column chart

@kaimoon31 it is very common problem, you need to add aother column SalaryRangeSort in you model with similar if condition but instead give it a number,  replacce "0-500" with 1, "500-1000" with 2 and so forth so on...

 

once you have new column added, go to modelling tab, select salary range column and in sort by drop down, select salaryrangesort

 

here is example image from my sample dataset

 

image.png

 

 

That's it, it will fix the issue.

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.