How to sort a Day Slicer to Mon-->Sun in an Excel Data Model

[Sinuhet]

I have 15 pivot tables in one workbook. All 15 pivot tables are part of the same data model.
I have 3 slicers: Day, Month, Year. All 3 slicers are connected to all 15 pivot tables.

The cells in column Day are reffered to a Date Column. I tried both TEXT([@Date],"dddd") and WEEKDAY([@Date],1).
The problem is the Day slicer is alphabetically ordered Fri-Mon-Sat-Sun-Thu-Tue-Wed.

How can I order it starting from Mon and ending with Sunday?
I cannot use a custom sorting list as this is not available within the Excel Data Model.

Do I need to create a separate index column for Mon to Sun in Power Pivot simillary to Day Index column (0-365) and Month Index column (1-12)?

Any advice would be highly appreciated.

 

[johnny51981]

Create a Custom List.

Excel Options > Advance > Scroll all the way to the bottom to the General Section > click "Edit Custom Lists..."

In the "List entries:" section, enter in the days of the week, in the order that you would like it to be. Hit your Enter key after each day to allow them to be shown on separate lines.

Click the "Add" button. The list will then shift over to the left side in the "Custom lists:" section. Click OK and then Save.

If it doesn't sort your Slicer right away, it will do so after a close and reopen of the file.

Hope this helps.

 

[Sinuhet]

correct me if I am wrong but sorting of slicer with the help of custom list is not available if the pivota tables are part of a data model. The option to check "Use custom list when sorting" is not available if I have added pivot tables into a data model.
Any other suggestions? I am afraid I have to add my pivot tables to a data model.