How do I sort my column headers in Power BI matrix visual to start on Monday?

[Anonymous00729]

Hi all,

I've been trying to wrap my head around this... I have a Power BI matrix visual where I want to show Day Name has column headers, Hour by rows and Total Revenue by values. However, trying to re-arange the Day Name to start on Monday seems a little mind-boggling. Here's the DAX code I've been using:

But, my matrix looks like this...

I want my column headers to be arranged so that it starts from Monday. Please help.

Thank you.

[grognard · Accepted solution]

To sort Matrix visualizations (and slicers) we need to use the "Sort by column” feature to sort our original (display) column, by another (index) column. Modify your table to include an index column like this: 
 

Date = ADDCOLUMNS(
    CALENDAR(DATE(2023,1,1),DATE(2023,12,31)),
    "Year",YEAR([Date]),
    "QuarterNr",QUARTER([Date]),
    "Quarter",FORMAT([Date],"\QQ"),
    "MonthNr",MONTH([Date]),
    "Month",FORMAT([Date],"MM"),
    "DayNr",WEEKDAY([Date],2),
    "Day",FORMAT([Date],"DDDD"),
    "DayIndex",IF(FORMAT([Date],"w")="1","7",FORMAT(WEEKDAY([Date])-1,"####"))
)

Then selecting the “Day” column, going to “Column tools” in the ribbon, and selecting the “Sort by column” button, then under that menu selecing “DayIndex”/whatever column you want to sort the display column by.  

Hope this helps. 

[Anonymous00729]

Thank you so much @grognard , your solution was exactly what I needed. Much appreciated!!! 😁🙏