Forum Discussion

sgallo's avatar
sgallo
Advocate V
2 years ago
Solved

Sorting Columns in Matrix by Day Part

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!

  • 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:

     

     

1 Reply

  • 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: