Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
JeroenR
Helper V
Helper V

Year week slicer filter visual only on selected year

Hi all,

 

I have a year week slicer on my page, see below images how it looks like.

JeroenR_0-1607356295887.png

JeroenR_1-1607356330412.png

 

This works perfect for all the visuals where I want to display the data of the selected period. But I also have a visual where I display a table, here I want to display all the weeks of the selected year and I can't get this to work. 

 

I want to achieve the following, displaying all the weeks based on the selected year / week that the user has filtered with the slicer.

JeroenR_2-1607356610961.png

 

Can someone help me out with this? 

 

 

1 ACCEPTED SOLUTION
Johanno
Responsive Resident
Responsive Resident

I don't think there are any other ways then using Edit interactions or the ALL function in a measure. So I think you have to use it in a creative way, either duplicate your measures and have one group with ALL and one without. OR maybe split your slicer in one year and one week slicer and you can edit interactions independently.

View solution in original post

4 REPLIES 4
Johanno
Responsive Resident
Responsive Resident

If you want a certain visual to ignore the slicer you can use Format - Edit interactions. But I understand that you want it to ignore week but not year, right? Then you in your measure would need to use the ALL function, like ALL(weeks).

Thank you for your reply, @Johanno . Yes that is correct, I want to ignore week but not year.

Is it also possible to solve this without editing the measure? For this visual I am using 3 measures which I am also using on other visuals. 

Johanno
Responsive Resident
Responsive Resident

I don't think there are any other ways then using Edit interactions or the ALL function in a measure. So I think you have to use it in a creative way, either duplicate your measures and have one group with ALL and one without. OR maybe split your slicer in one year and one week slicer and you can edit interactions independently.

Thank you for your answer. I hoped that there was another solution to solve this. Unfortunately there isn't one, I will probably seperate the filters. Thats the easiest and probably best way to solve this.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.