Forum Discussion
Resolver IIICustom 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.
Resolver IIIThanks Cherry for reaching out.
I have shared the test file link in my post. Categorical won't help because x-axis is having data values for every 5 min for 24 hours. It will make this axis long. I am trying to achieve this using continuous only.
Resolver IIIHi Guys,
Just checking in if this is something which we can't achieve in Power BI? Please let me know what you think?
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.
- parry2k
Super User
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.
- MannHi 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.
