+ Reply to Thread
Results 1 to 2 of 2

Slicer Interaction Issue in Power Pivot – Measures and Filters

  1. #1
    Registered User
    Join Date
    11-10-2023
    Location
    Tbilisi
    MS-Off Ver
    2021
    Posts
    1

    Post Slicer Interaction Issue in Power Pivot – Measures and Filters

    I am encountering an issue while working in Power Pivot, specifically with slicer interaction. In my setup, I have multiple tables linked to each other, and I am utilizing measures in a pivot table for calculations. To enhance user interactivity, I have implemented slicers based on the main data table.

    The problem arises when I use these slicers to filter the data. While the slicers successfully filter the pivot table based on the selected criteria (e.g., product type like "vegetables"), they do not seem to communicate with each other. Consequently, when I click on a specific product type in one slicer, such as "vegetables," the pivot table is appropriately filtered (and measures work correctly). However, the second slicer, which should display products related to the chosen product type (e.g., "carrot," "Potato"), remains unaffected.

    Desired Outcome:

    I would like the slicers to work in tandem, ensuring that when I select a product type in one slicer, both the pivot table and the other slicers update accordingly. This synchronized behavior would enhance the overall functionality and usability of the Power Pivot setup.

    Steps Taken:

    Ensured proper table relationships.
    Verified the correctness of the measures used in the pivot table.
    Confirmed that slicers are sourced from the main data table.

    Any insights or guidance on resolving this issue would be greatly appreciated.

    Thank you!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,403

    Re: Slicer Interaction Issue in Power Pivot ? Measures and Filters

    Hello Ialeqsaia and Welcome to Excel Forum.
    Someone may be better able to help if we could see a sample of the file that is causing the issue.
    Information on attaching a sample file to your next post is given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power Pivot - filtering and slicer
    By RE_NERO in forum Excel General
    Replies: 3
    Last Post: 04-21-2023, 05:56 PM
  2. [SOLVED] Large function does not appear in Power Pivot measures
    By viewotst in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-07-2022, 08:41 AM
  3. Power Pivot - Calculated Measures
    By newmaldener in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2021, 02:21 PM
  4. Power Pivot Totaling Measures
    By fbataille in forum Excel General
    Replies: 0
    Last Post: 09-24-2020, 04:34 PM
  5. Help needed with fx Measures (Calculated fields) with Power Pivot
    By redalert787 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2020, 09:49 PM
  6. Connecting Sloicer from Power Pivot to Slicer from Regular Pivot
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-27-2015, 06:13 AM
  7. Only display certain Values in the Slicer for Power Pivot
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-15-2015, 03:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1