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.
Dear BI users,
Hope you to share creative ideas about below issue.
Objectives
Problems
Question
Alternative
Sincerely,
Lee, Hong Gwoo
Solved! Go to Solution.
Hi @extri13,
As your post, ALL() function ignores all slicers and Visual/Page/Report filters. In order to apply only Page Level Filter not by a slicer on the page, you would need to use ALLSELECTED() function instead of ALL() function, and utilize "Edit Interaction” feature(Alternative #2). ALLSELECTED is removing only filters created by the rows/columns in the current query, but retains explicit filters. For more details about difference between ALL() and ALLSELECTED(), please review this similar blog.
In addition, comparing to Alternative #1, Alternative #2 is more practical and more convenient. For more details, please review the example in the attached PBIX file.
Thanks,
Lydia Zhang
Hi @extri13,
As your post, ALL() function ignores all slicers and Visual/Page/Report filters. In order to apply only Page Level Filter not by a slicer on the page, you would need to use ALLSELECTED() function instead of ALL() function, and utilize "Edit Interaction” feature(Alternative #2). ALLSELECTED is removing only filters created by the rows/columns in the current query, but retains explicit filters. For more details about difference between ALL() and ALLSELECTED(), please review this similar blog.
In addition, comparing to Alternative #1, Alternative #2 is more practical and more convenient. For more details, please review the example in the attached PBIX file.
Thanks,
Lydia Zhang
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 |
---|---|
111 | |
101 | |
76 | |
64 | |
63 |
User | Count |
---|---|
141 | |
105 | |
101 | |
80 | |
67 |