I thought it was easy, but I don't know how.I would like to sort this drop-down list accordingly.
How can I do this without affecting the rest of my modeling?
Thank you so much for your help!
Go to Solution.
Hi @qwertzuiop ,
We can create a seprate calculated table to meet your requirement:
DISTINCT ( 'Table'[Wochentag-kurz] ),
"Index", SWITCH (
Then set the name column sort by index column and create a relationship between the origin table.
Then we can use the name column in new sort table as the slicer field without changing the origin table.
BTW, pbix as attached.
Best regards,Community Support Team _ Dong LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@qwertzuiop You can do this in M (Power Query) or DAX in a calculated column. This post covers both options -> https://community.powerbi.com/t5/Desktop/Sort-by-Day-of-week/td-p/338758
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!