I have used the below DAX
WeekDay = format(Test[FIRST_TOUCH_DATE_TIME],"dddd")
and it gives me this:
Saturday, sunday, Monday i.e Week day names, but I nned to show the name in a sorted order like Monday, Tuesday, Wednesday..
Currently it is hown as below, so how can I achieve this?
Go to Solution.
There is no direct option to sort week day, try to sort manually by the following way-
For more details see the pbix file. Hope this will help you!!!
Download pbix file
Add a new column with the weekday number and then sort Weekday by WeekDay number in Table view
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.