X axis sort with data

[Karthik12]

Hello Team,

I have column chart where start time, end time , Shift is X axis. But while showing in visualization , Shift is not showing in order. I tried to sort but couldn't. Can you help us?

"I need sort General shift followed by Third"

[Suresh604]

1. Add a Custom Sort Column:

   • In your data table, create a new column named something like "Shift Order."
   • Assign the value 1 to "General" shifts and 2 to "Third" shifts.
   Start Time End Time Shift Shift Order

   08:00	16:00	General shift	1
   16:00	00:00	Third shift	2

2. Sort Your Data:

   • Go to your column chart settings.
   • Find the sorting options.
   • Sort by "Shift Order" instead of the "Shift" label.

This should arrange your shifts in the desired order, with "General shift" appearing first, followed by "Third shift."

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Suresh Patra
https://www.linkedin.com/in/sureshpatra

[Karthik12]

Hi @Suresh604 

I have added one more column ShiftOrder. You mean that, we need to add this Shiftorder in the X axis of bar graph? Also, may I know, where is the column sorting option?

[Ritaf1983]

Hi @Karthik12 
You have to add a sorting column for Time key to your data table .
For more details please refer :

https://www.youtube.com/watch?v=1saRnlIHZVw

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.