Forum Discussion
Custom Sorting the x-axis with time value
- Hi Parry,
Thanks for the reply. If I make x axis categorical then it extends the length of x axis which is not the requirement. So instead of using time value on x-axis, I used date time column and used a time slicer. Everytime user selects any date or date range graphs changes accordingly but keeps continuous x axis.
see if this is what you had in mind:
Key here is use the the Movement Hour from yoru Order table in the chart, be sure to sort that column by your sort column in that table, and keep the formatting as text. When switched to a time it defaults to 12:00:00 for some reason.
Mann I looked at your pbix file and here is what you need to do to make it works:
- Sort "Movement Hour" in order tabe by sort order.
- drop "Movement Hour" on x-axis and application_id from main table on values
- on format page, change "type" of x-axis to "categorical" instead of "continuous"
and that will do it.
- Hi Parry,
Thanks for the reply. If I make x axis categorical then it extends the length of x axis which is not the requirement. So instead of using time value on x-axis, I used date time column and used a time slicer. Everytime user selects any date or date range graphs changes accordingly but keeps continuous x axis.Hi Mann,
It seems that you have find a workaround. Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
