Forum Discussion
Sorting Time of Day on Chart
Hi knightkblack,
Based on my test, you can refer to below steps:
1.You can create a table like following one and create relationship with the original table.
2.Create a calculated column in original table with following formula.
New = RELATED(Sheet2[Order])
3.Select the Type column and make it sorted by above created column.
4.Create a Clustered column chart and add the [Hours] and [Minute] fields. And sort by the “Sort by Hours”. Now you can see the result.
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/6fnqplx7v8p2yav/Sorting%20Time%20of%20Day%20on%20Chart.pbix?dl=0
Regards,
Daniel He
Microsoft EmployeeHi knightkblack,
Based on my test, you can refer to below steps:
1.You can create a table like following one and create relationship with the original table.
2.Create a calculated column in original table with following formula.
New = RELATED(Sheet2[Order])
3.Select the Type column and make it sorted by above created column.
4.Create a Clustered column chart and add the [Hours] and [Minute] fields. And sort by the “Sort by Hours”. Now you can see the result.
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/6fnqplx7v8p2yav/Sorting%20Time%20of%20Day%20on%20Chart.pbix?dl=0
Regards,
Daniel He