Hello Team, I've complained about this before and was told "It's working as designed." If this is the case, the design is flawed. It's 2024, and still the ability to paste a list into a slicer and sync across all tabs is not a standard capability of Power BI blows my mind. We could do this with Qlik ten years ago. Without a standard feature, we resort to custom visuals -- Mass Filter and Filter by List. Both were working just find for a couple years, syncing across tabs. Well, something changed earlier this year and they no longer sync across pages. Team, my users often need to paste hundreds of values into a slicer, and I'm sure many companies are the same in this regard. We are left with pasting a list into Mass Filter and then once the page is filtered to these values, clicking boxes in the standard slicer one by one by one hundreds of times. So the standard slicer filters throughout the entire report. Since this is such a waste of time and in Power BI features are always changing, I thought I'd take another stab at looking for a workaround only to become extremely frustrated. I decided to try Select All again, but it sucks because it provides absolutely no value. Here are the steps: 1. Paste a list of customer IDs into the Mass filter on one tab. 2. On the same tab, I go to the standard customer ID slicer and click Select All. Good, now the standard slicer, which syncs across pages has only the customer IDs I want to filter to. 3. However, when I visit another tab in the report, ALL customer IDs are selected. What is the point of this? The behavior is the same as if no values were selected. Default is ALL. Okay, let's try something else. I've seen Microsoft posts about how Select All is meant to be used to look at a set of data and EXCLUDE values. So then I try this approach: 1. Paste a list of customer IDs into the Mass filter on one tab, including an actual customer ID I do NOT need. 2. On the same tab, I go to the standard customer ID slicer and click Select All. 3. On this same tab now in the standard customer ID slicer I UNCHECK the customer ID that I do not need. Good, now the standard slicer, which syncs across pages, has only the customer IDs I want to filter to. 4. However, when I visit another tab in the report, ALL customer IDs are selected (I mean, ALL, not all I selected in Mass Filter, but literally ALL of our customer IDs), except for the single one I unselected. Microsoft Team, please take some good action on this. We need a way to paste a list of values and sync entire reports.
... View more