How to sort as 1, 2, 3... as numbers instead of text sorting in a slicer

[Anonymous]

 Hello, 

 I have a slicer that looks like that

 I wanted to see if someone may have an idea how I can sort it as 1 week ago, 2 weeks ago, 3 weeks ago etc. I believe right now it is saved as text. 

 Please let me know if someone knows. 

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

You need to add index for current text slicer table:

Choose  sort by index:

Final:

refer:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[VahidDM]

Hi @Anonymous 

Have you tried to sort ascending?

Click on the ... ellipsis on top of the slicer and select sort ascending

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/