cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Freeseman
Helper II
Helper II

Sort Date from 18:00 to 17:00

Hi All,

 

Is there a way to sort my date in 24h day from 18:00 start to 17:00 end and not from 00:00 to 23:00

So in other words like this...

Freeseman_1-1660049407457.png

I am trying to structure my X axis by hour but in a specific order. So by default Power BI would arrange my hours from 0 - 23

or it would kind of just mix them up as below.

Freeseman_0-1660049351800.png

The result i am trying to acheive is like this:

Freeseman_1-1660049407457.png

Please help me in the right direction to replicate the second visual

1 ACCEPTED SOLUTION
Payeras_BI
Solution Sage
Solution Sage

Hi @Freeseman ,

Create an additional column assigning the order you desire and then sort the Hour column by that column.

Payeras_BI_0-1660125976302.png

Payeras_BI_1-1660125998680.png

 

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

3 REPLIES 3
Freeseman
Helper II
Helper II

Okay the logic behind what you explained was helpful. @Payeras_BI Thank you. I have managed to do this using conditions.

 

Freeseman_0-1660129370672.png

 

Payeras_BI
Solution Sage
Solution Sage

Hi @Freeseman ,

Create an additional column assigning the order you desire and then sort the Hour column by that column.

Payeras_BI_0-1660125976302.png

Payeras_BI_1-1660125998680.png

 

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

Thank you @Payeras_BI for reaching out with assistance. I am not sure how you did this. I have multiple rows with times and i want to do like you suggest to order but they dont match up.

 

Freeseman_0-1660126852063.png

How do i make a column to only look at hours 18pm to 17pm and arnage them like you mentioned.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors