Power Pivot Relationship Not working causing data not to filter

DMfba

New Member
Joined
Mar 21, 2019
Messages
22
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

Well-known Member
Joined
Oct 24, 2015
Messages
7,435
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 ;)
 
Last edited:

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

DMfba

New Member
Joined
Mar 21, 2019
Messages
22
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

Well-known Member
Joined
Oct 24, 2015
Messages
7,435
You are welcome & thanks for the feedback
Have a nice day (y)
 

Watch MrExcel Video

Forum statistics

Threads
1,119,015
Messages
5,575,554
Members
412,676
Latest member
Davejf81
Top