Forum Discussion
Sort by time
Hi there,
I am creating a report using Line Chart where I want to show count based on hours.
Can anyone help me to sort out the time in a proper order.
I want it to be like 7 AM, 8AM, 9 AM,10 AM, etc.
Hello Anonymous ,
Follow below steps to achieve this.
1. In Power Query create two columns. one for time and other for hour (hour column is created from the time column)
2. Make sure the hour column data is from 1-24 instead of AM-PM
3. Once data is loaded to Power BI Desktop, select the time column and sort it using hour column under the option sort by column
4. Use this time column in the visual then it will sort in proper order.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
3 Replies
Anonymous can you share a sample dataset that you are using (after removing sensitive information)
Hi AbbasG,
you can consider this as sample data
Time Logged Hours 7 AM 6 8 AM 7 9 AM 8 10 AM 4 11 AM 3 12 PM 8 1 PM 2 2 PM 4
Hello Anonymous ,
Follow below steps to achieve this.
1. In Power Query create two columns. one for time and other for hour (hour column is created from the time column)
2. Make sure the hour column data is from 1-24 instead of AM-PM
3. Once data is loaded to Power BI Desktop, select the time column and sort it using hour column under the option sort by column
4. Use this time column in the visual then it will sort in proper order.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
