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.
Is it possible to create a filter that will independently filter another filter without changing the visualizations? Here is my scenerio, in an SSRS report, my users had the option to pick a week range which could go back to 20 entries. I am trying to recreate it in PowerBI but with option of choosing TopN weeks that they want displayed in the weeks filter
I think this is possible, but might be a bit tedious to do.
If you go to the Format tab, you'll find a button on the far right called Edit Interactions. This allows you to manage how the selected slicer influences other objects in the report.
In the example pic, I have the Salesperson ID slicer selected. Now what I can do is click on the funnel to allow interactions with the target object, or the circle/line, do disable interactions with the target object.
In your case, I think you'll need to select the slicer, and then disable interaction on every object except the one with the weeks in it. Then the slicer with the Weeks, can used to influence the rest of the report.
You might have to do some trial and error on this, but this should at least get you going down the right road.
Good luck,
Nate
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |