Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Week number calculation

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.

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.