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 re...
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