Forum Discussion
X axis sort with data
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 n...
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.
08:00 16:00 General shift 1 16:00 00:00 Third shift 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
