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.
Hi, just a simple question:
I would like days to be in the correct order on my axis, like Monday, Tuesday, Wednesday, etc.
Please take a look at the images attached and you will understand what I mean.
Thank you for your time!
Solved! Go to Solution.
You need to use the Sort By Column feature for this. Please see this link. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
You can use your DayOfWeek column to sort the day name column.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@pal95 ,
Add a column
week day = weekday([Date],2)
And sort you weekday name on this
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
First Createa new calculated column for Day of week
Second, sort your [Day] column by your newly created [Day of Week] column.
Highlight the [Day] column
Click Modeling -> Click Sort By Column -> click [Day of Week]
You need to use the Sort By Column feature for this. Please see this link. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
You can use your DayOfWeek column to sort the day name column.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.