Sorting a filter

[Anonymous]

Hello, I'm new at Power BI and at the X axis I have the weeks, and I've the amount of sales of that week at Y axis. But when I put the filter it's really strange the sort of the filter, right now I've it as the following:

-week 1

- week 10

- week 2

- week 3

- week 4

-week 5

- week 6

- week 7

- week 8

- week 9

Does any body know how to help me? I don't know why week 10 isn't after week 9

[user01 · Accepted solution]

Because 1 comes before 9. The week number should have a leading zero, ie. Week 01, Week 02, ... Week 09, Week 10. Alternatively, trying making another column with the order ("Order") you want, then sort your "Week" column by the "Order" column using the Column Tools > Sort by column.

Something like this:

https://community.fabric.microsoft.com/t5/Desktop/Sorting-the-Slicer/m-p/24565

[Anonymous]

Thanks a lot! It worked perfectly

[vanessafvg]

because its a text field not a date or number field. do you have a date table?

[Anonymous]

Yes I have date, and for example I have 1/01/2024 in column b and in column A I have week 7