Forum Discussion
sgallo
2 years agoAdvocate V
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
- SamWiseOwlSuper User
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: