The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
@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
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?
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.