Forum Discussion
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.
| 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.
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.
3 Replies
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
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.
