Forum Discussion
Sort chart x axis
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.
Hi people anyone know how i can have the x axis appearing as in the screenshot please?
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.
Hi,
Thank you so much for you help. I am almost there. The below is how mine is appearing
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.
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.
Hi,
In the same column chart, is there a way to sort the columns by decreasing value? so for example, within 2016, we will see the column with the highest value left. Thanks