How to get date and hour in the x-axis for a line chart.

[Anonymous]

Is there any method to arrange the hour in increasing order for the below visual. In x-axis i want to see the count with date and hour both, eg: 21-09-2020 0, 21-09-2020 1 21-09-2020 2 ---- 21-09-2020 24 and then the next date starts (date hour format)

[Sumanth_23]

hi @Anonymous - you can create a calculated column to derive the Year+Month+day+hour in the format required for your report and sort the same by date time field available in your data 

1. You can derive the year, month, day and hour from your dateime field in Query editor as seen below 

2. Create the calculated column to use in your reporting:

Report Date-Hour = 'Z-DateTime-Sort'[Year] & 'Z-DateTime-Sort'[Month] & 'Z-DateTime-Sort'[Day] & "-" & 'Z-DateTime-Sort'[Hour]

3. Sort your Report Date-Hour field by the date time field in your data 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[amitchandak · Accepted solution]

@Anonymous , make sure date is date and hour is in number. And try Concat label off mode or on mode.

Screenshot only show the option

[Anonymous]

Thank you for the help. Now I have a concern that I need the date to be displayed only once (eg: 17-09-2020 0 to 24 hrs then 18-09-2020 0-24 hrs and so on) because the visual is looking conjested. And also Is there any way to remove the scroll bar so that i can display the 7 relative date in a single visual and without the scroll bar.

[Sumanth_23]

hi @Anonymous, 

1. You can adjust the page width by changing to custom and adjusting to the width required - as seen in the below screenshot 

2. You can use the date hierarchy Uwithout quarter and the derived hours to display as seen below - this will the X-axis look less cluttered

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!