My Power Pivot doesnt seem to show the relationship in pivottable

Audrey Yip 1 Reputation point

lant and product ID is from one table and i created a relationship to link to Plant and product ID in another table (the relationship is created).but the pivot table below doesnt seem to recognise this relationship.

if i choose another datapoint from the table 2 (where the second Plant and Product ID info is stored), then it seems the relationship is recognised


Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,811 Reputation points Microsoft Vendor

    Hi @Audrey Yip ,
    Did you clear all the filter first and then re-filter in the second Table?
    How did you filter?
    It's not very clearly the problem about the PivotTables, please be a bit more precise to explain your problem so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
    I also suggest you refer to the article and check the part of Notes about Relationships:

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments