Sorting Columns in Matrix by Day Part

[sgallo]

Hi all,

I am trying to order the columns in a Matrix by the Day Part so that the order is Morning-Lunch-Afternoon and not as below alphabetically A-Z:

I tried to opend the semantic model and try to order in various ways the table where the day part is in it - both in Power Query and in the table view.
Note that DayPart and Weekpart are form 2 different tables but are needed to be shown together in a drill down as in the screenshot.

Is there a way to change the order for the day part?

Thanks!

[SamWiseOwl · Accepted solution]

Hi @sgallo 

Could you in the data or in a seperate table create a sort id:

Then tell Power BI to sort the Day by this value: