Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
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.