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
Rena
Resolver II
Resolver II

Table Help

I am making this way harder than it needs to be so I just deleted and need to start over.  Please help.

 

I need to convert my data into a table. That looks like this.

 SunMonTueWedThuFriSatTotal
Planned1001009550150150150795
Actual1051108060150180130815

 

This is my data

Rena_0-1751031629436.png

 

I can't get the table to sort Sun - Sat and I can't get it to show the rows correctly.  It keeps looking like this.

Rena_1-1751031784378.png

 

 

 

1 ACCEPTED SOLUTION
MasonMA
Memorable Member
Memorable Member

then you would need to follow the same logic to either create one Column with DAX like 

HourSort = 
SWITCH(
    TRUE(),
    HourBlock = "7–8AM", 1,
    HourBlock = "8–9AM", 2,
    HourBlock = "9–10AM", 3,
    HourBlock = "10–11AM", 4,
    ...
)

or i personally would prefer to use Add Column in Power Query to have them transformed in Power Query. 

 

View solution in original post

3 REPLIES 3
MasonMA
Memorable Member
Memorable Member

@Rena Hi, Power BI sorts alphabetically by default. if you wanted to sort them your way, you would need to create a column, say 'DaySort' column by, 

DaySort = WEEKDAY('Table'[Date], 1)  

which returns 1 for Sunday to 7 for Saturday. 

then In the 'Data view', select the 'Table'[DayOfWeek]' colum, go to the ribbon and Sort by Column by using DaySort

 


@MasonMA 

I got that to work, but now I need my [Hour Block] to also have a sort feature.  Is there a way to do two sort columns?

 

MasonMA
Memorable Member
Memorable Member

then you would need to follow the same logic to either create one Column with DAX like 

HourSort = 
SWITCH(
    TRUE(),
    HourBlock = "7–8AM", 1,
    HourBlock = "8–9AM", 2,
    HourBlock = "9–10AM", 3,
    HourBlock = "10–11AM", 4,
    ...
)

or i personally would prefer to use Add Column in Power Query to have them transformed in Power Query. 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors