Table Help

[Rena]

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.

	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Total
Planned	100	100	95	50	150	150	150	795
Actual	105	110	80	60	150	180	130	815

This is my data

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.

[MasonMA]

@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

[Rena]

@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 · Accepted solution]

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.