Custom Week number 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

[v-xicai]

Hi  @FCF ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

Best regards

Amy Cai

[v-xicai]

Hi @FCF ,

If you need to show the whole week number series in your order, you can add custom visual "Timeline", and you can select any time range but needn't to enter the week number which will be shown in the visual "Timeline".

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.