Solved

Synced Super Filter: toggles sync across sheets, but the visuals don't update

Started by jonchen.wong · 1 month ago · 1 reply · 146 views
jonchen.wong Participant
1 month ago

Hi all,

I have two intelligence sheets (Top Down and Bottom Up) with the same Customer Posting Group Super Filter on both. I want a viewer to set the filter once and see the same selection on both sheets.

I set it up with Layout pane › Sync Slicer: both sheets ticked for Sync + Visible, same group name on both filters, "Sync field changes to other slicers" on. Screenshot 1

What happens (Reading mode):

  • Top Down: switch EU off → open Bottom Up → EU is off and the numbers are correct. ✅
  • Bottom Up: switch EU back on → open Top Down → the filter shows EU on, but the numbers still exclude EU (Plan Sales 26.2m instead of 39.2m, and the table shows no EU customers). Refresh Data didn't help. ❌ Screenshot 2
  • Same in the other direction: switch NA off on Top Down → Bottom Up shows NA off, but the numbers still include NA.

So the toggle state syncs, but a sheet that's already been opened doesn't re-query. The filter and the numbers disagree, which is worse than no sync, because people trust what the filter says.

Two smaller things:

  1. Filter state after a reload. After reloading, Bottom Up's filter shows every toggle off, while the synced filter on Top Down shows them all on, and the data includes everything. Screenshot 3 (frames ① ②)
  2. Logo blank. The logo image on Bottom Up is blank on most loads; the same logo on Top Down is fine. Screenshot 3 (frame ③)

Side note: when I first tried this, I ticked the other sheet in the Sync Slicer list. That dropped a hidden copy of the filter onto that sheet, right on top of its own filter, so it showed blank. Unticking Sync didn't remove the hidden copy.

Questions

  1. Is this a known bug, or am I setting up Sync Slicer wrong?
  2. What's the recommended way to keep one filter in sync across intelligence sheets?
  3. Is there a fix for the image/logo that sometimes renders blank?

Thanks!

1 Reply
Aparna JegannathanLumel Staff
Lumel · 2 weeks, 2 days ago

Hi Jonchen,

Thank you for the details.

  1. Is this a known bug, or am I setting up Sync Slicer wrong? -

    Your Sync Slicer configuration appears to be correct. However, while the slicer selection is syncing as expected, the visuals are not consistently refreshing to reflect the updated selection. This can cause the slicer state and the displayed data to become out of sync.

    Our Team is actively working on it for the upcoming release. We shall keep you updated on further developments.

  2. What's the recommended way to keep one filter in sync across intelligence sheets?The recommended approach is to use Sync Slicer with the same field and the same Sync Group name across all participating sheets. Additionally, ensure that Sync field changes to other slicers is enabled on each sheet.

    This is the supported method for keeping slicer selections synchronized across Intelligence sheets.

  3. Is there a fix for the image/logo that sometimes renders blank?We are tracking it independently and plan to include a fix in a future release. We shall keep you updated on further developments.

    Stay tuned for further updates!

Viewing 1 replies (of 1 total)

Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.