Forum Discussion

tomwwagstaffRIT's avatar
tomwwagstaffRIT
Frequent Visitor
8 years ago
Solved

Sort chart x axis

Hi everyone,   This seems an extremely basic problem, but I can't sort a graph by its x-axis alphabetically. Here is a reproducible example:   Take this dummy data: Letter Number A 1 ...
  • danextian's avatar
    danextian
    8 years ago

     Hi tomwwagstaffRIT,

     

    Based on your screenshot, Sort by Category has already been activated. Just click again on Z-A icon. It should change to A-Z once the sort order has been changed to ascending.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

> Select a column or line visual. On the X axis drag drop a date field (Data type should be "Date").  On the axis option, select "Date Hierarchy" and get rid of Quarter and Day. Also click on the drill down to "At lowest level of Data". Your visual should look something like below: 

 

> go to "Format your visual" > X axis > and turn OFF "Concatenate Labels": 

 

This should do the trick. 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi 

 

Thank you for your help. The below is how mine is appearing. Any idea how i can get this similar to yours? I have followed the instructions you have sent but it was difficult for me to see the images clearly due to the resolution. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hey Anonymous 

    You're almost there, the only step left is go to "Format the visual" > Go to X Axis > Go to Concatenate labels and turn it off 

    That should do the trick. 

    Please accept the answer as solution if this works. Cheers. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      awesome, thanks-I was missing the conctaenate labels part 🙂