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!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!