Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @collinq I appriciate your response. But that way it will not give a desired result. for example i selected 2021 to 2022 in year filter and 30 to 10 in week filter. It will show me the data, first for year 2021 and weeks (from 10 to 30 weeks) and then for 2022 year. I think might need some dax calculation.
Hi @Burhan ,
Just to clarify - I am suggesting a single slicer, with the hierarchy in it - where the user can pick the months of the year. Something like this:
And, you could update that to have numbers for the months or to organize it differently to make more sense to you and/or your users (fiscal year months, quarters, or whatever).
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @Burhan ,
I think that the easiest way to do this would be a slicer with the year and week number hierarchy in it. That would allow the user to select the weeks and the years.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.