Period Slicer showing numbers not existing, any solution?

[Stoppelaar]

Hi,

I am using a Period slicer on Year & Week, the user can write the year and week and get the data he/she needs but I would like to have the scroll bar, so it's even easier but I have not found a solution where the scroll goes from 202201 to 202252, it keeps going to 202299 and that data does not exist in my table...

Is there a solution on this or is it just to accept or take a another option?

Many thanks,

Andreas

[v-zhangti]

Hi, @Stoppelaar 

You can try the following methods.

Column:

Weeknum = WEEKNUM([Date],2)

Period = YEAR([Date])*100+[Weeknum]

Is this the result you expect? If not, please provide more information.

Best Regards,

Community Support Team _Charlotte

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

[Stoppelaar]

Thanks @v-zhangti  for your answers! 

I have tested it but with the same result! 

So if you are only looking on 1 year then there are no problem, it's when you move from one year to the next you get weeks not existing in the data from week 52(53) to 99!

It might be that there are no solution but it's a bit strange that it makes up numbers that is not in the acctual table?