Forum Discussion
Solved
Custom Sorting the x-axis with time value
Hi All, I created a simple line graph with Time values in X axis and Measure dropped to value area as shown. X axis: Column "Time" coming from Table A having time values like (08:00 AM, 08:05 AM,...
- 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.
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.
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
