how to create a custom timeline week slicer

[FCF]

Hi

our fiscal year starts Aug 1st, and end the following year on July 31st.

We start our fiscal year on week 31.

when i set up a slicer i cannot  use the slicer to display weeks in the following order

31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,

when i use a time line slicer i cannot enter weeks 31 to 19, 

31 is the first week in our fiscal year, 19 is the current week # that i am writing this post.

any help would be greatly appreciated

Regards

[Michiel]

What you need, is a separate column in your calendar table with the 'fiscal week' number (so 31 = 1, 32 = 2, etc.) Now, use the 'Sort by Column' option to instruct Power BI to sort the normal week number by the corresponding fiscal week value.

[FCF]

hi thanks for the response but that is not quite what i am lookin for. in the timeline slicer i want to be able to enter week 31 to week 19.

Week 31 is the first week of our fiscal starting in august 20183

week 19 the current week in may 209

[v-lili6-msft]

hi, @FCF 

For custom sort in the visual, you could use Sort by column in Power BI Desktop.

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

But it couldn't be achieved in the numeric range slicer("between").

https://docs.microsoft.com/en-us/power-bi/desktop-slicer-numeric-range

As a workaround, you drag the new column  'fiscal week' number as a timeline week slicer.

Best Regards,

Lin