Sorting Time from 6 AM to 6 PM for Day Shift and 6 PM to 6 AM for Night Shift

[KevinJan]

Hi All,

I am struggling to sort my chart based on the time. 

Currently, I have Day Shift as 6 AM to 6 PM and Night Shift as 6 PM to 6 AM but when I create a chart, it doesn't sort the way I wanted it. 

I even created a query with index to sort it by index column but for some reason, its now matching/working. 

Chart:

Data set:

New  query to sort the time:

[v-chenwuz-msft]

Hi @KevinJan ,

1 Change the x axis with [column1] shows in the New query and build a relationship between fact table and New query table on time2 and column1.

2 Please try change the X-axis type to categorical.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@KevinJan . You have marked that column as sort column for the time column and you have sorted visual on time using three dots

[KevinJan]

Hi @amitchandak , 

Sorry but I am unable to follow the steps you mentioned. Can you clarify a bit futher please. Sorry I am fairly new to PBI