Power Pivot Relationship Not working causing data not to filter

[DMfba]

I have what I believe is a relationship error in Power Pivot that I can’t seem to figure out. I am attempting to combine multiple excel files and access tables using a unique list of customer vendor numbers. The goal is select the customer vendor number and have other Pivot tables filter based on that selection.

I loaded the various tables into power query, and made sure all of the formatting is correct. Next, I open Power Pivot and set the relationships from my Main Vendor list (unique IDs) over to the different tables. The plan is to use a slicer to filter the various pivot tables. However, there is 1 out of the 5 pivot tables that will not work properly. Basically, this table will not filter. The relationship in power query is connected to this table.

Does anyone have any suggestions on to check for? I created all of the different tables in the same manner and connected them in the same way. If I add the vendor # field to this last table, I can see the filter change as I change the slicer, but the data does not. It will only display the entire data table.

Thank You,

 

[sandy666]

my (natural) order is

1. add table(s) to Data Model
2. create relationships
3. create pivot table
4. create slicer (if necessary)
5. you can prepare proper tables in Power Query before point 1

honestly I really don't know what are you doing there so try to resolve it yourself. no pain, no gain

 

[DMfba]

Hi Sandy,

Thank you for your help. I rebuilt the file and its working properly. I don't have a real answer as to why it didn't work the first time. The only thing I can think of that I might have overlooked. Its possible I could of tested the table without the measurements in place. If I did, then it won't filter.

Thank you for the help, it did double checking my steps and making sure tables are correct.

 

[sandy666]

You are welcome & thanks for the feedback
Have a nice day