The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.