Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |