Reordering the hourly columns of the chart according to a personal order

[antonaccidavide]

Good morning everyone,
something that will probably be simple for many, but for me it is not.

I need to rearrange the order of the hourly columns of the graph according to a personal order, that is, given the 24 hours, I need to have an hourly graph that starts from 6pm and ends at 8am

I actually managed to reorder it via custom reorder columns, but then I don't have a correct reference in the X axis

This is a chart I created with python, again through power bi and it is as I would like it but using the standard power bi charts

This is how the Power BI chart appears to me, where I created a column that I used to reorder the columns, but I don't have a correct header on the X axis

How can I solve it?

[Greg_Deckler · Accepted solution]

@antonaccidavide Use a Sort By column on your original column of your correctly ordered column. Or you could just change the x-axis label

[Anonymous · Accepted solution]

Hi @antonaccidavide 

I’d like to acknowledge the valuable input provided by the @Greg_Deckler . His initial idea was instrumental in guiding my approach. Here is the specific testing I did about "Sort By column" for your referrence:

My sample:

1. Create a order table as follow

2. Merge two tables

3. Expand the table

Close & Apply

4. Select the Time column and Sort By column

Output:

If this sample data is structurally different from the one you are using, please do not hesitate to mention it and I will modify it.

Best Regards,
Yulia Xu

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

[Greg_Deckler · Accepted solution]

@antonaccidavide Use a Sort By column on your original column of your correctly ordered column. Or you could just change the x-axis label