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.
Hi all,
I have a year week slicer on my page, see below images how it looks like.
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.
Can someone help me out with this?
Solved! Go to Solution.
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.
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.
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.
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.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |