Week number calculation

[Anonymous]

I have one year fillter (Range filter) and one week number filter (Range filter). I want to caluculate values such that when i select year 2021 to 2022 and week number 42 to 10 it will first show data for 42th weeks to 52th weeks for year 2021 and for 1st week to 10 th weeks for year 2022.

Note. As there are 52 weeks in one year. I have attached my Dashboard screenshot.

[v-yanjiang-msft]

Hi @Anonymous ,

The range filter you are referring to is the Between type in the slicer? It only supports selection from small to large.

Best Regards,
Community Support Team _ kalyj

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