Forum Discussion

jmaclennan's avatar
jmaclennan
Copper Contributor
Oct 02, 2024

Building Dynamic Slicers with Relationships?

Hi there,

 

I am attempting to build a set of dynamic slicers based on the unique values from around 4 power query tables. I've followed step by step videos, and linked the tables based on their related column. When I try to create the pivot tables, I'm able to make the slicers, but the pivot tables don't change when I change the slicers. Does anyone know what the issue may be?

BI & Data Analysis
excel
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 02, 2024

    Hi jmaclennan 

     

    Usually this is because the Slicers are not connected to the PivotTable:

    • Select one of your Slicers
    • Go to Slicer tab > Report Connections
    • Make sure you have a check next to the appropriate PivotTable (ex. below):

    • jmaclennan's avatar
      jmaclennan
      Copper Contributor
      Oct 02, 2024

      Lorenzo 

       

      Hi Lorenzo, 

       

      Thanks so much for the response. I just checked, and it is connected correctly, any other thoughts as to what the issue could be?

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Oct 02, 2024

        jmaclennan 

        No other idea right now 😞

        Can you share your workbook (via OneDrive, Google Drive or the like)?

Resources