Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous00729
Regular Visitor

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

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:

 

Anonymous00729_0-1750078948368.png

 

But, my matrix looks like this...

Anonymous00729_1-1750079058987.png

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

Thank you.

1 ACCEPTED SOLUTION
grognard
Helper I
Helper I

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.  

 

grognard_2-1750093388424.png

 

 

Hope this helps. 

View solution in original post

2 REPLIES 2
grognard
Helper I
Helper I

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.  

 

grognard_2-1750093388424.png

 

 

Hope this helps. 

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

Anonymous00729_0-1750096966882.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors