November 28, 2021
Everywhere I look. The only examples are how to use ONE slicer on two different tables of information. Too simplistic.
My need is, I have 3 tables of information. They each have 8 collumns that are relatable and can be used for slicers.
SO, how can I create 8 slicers to impact pivots from 3 different data tables ?
Does anyone know of any video, or tutorial or anywhere I can find this? Many Thanks !
I tried setting up a unique table, call it the SlicerTable. It has the 8 collumns, with NO duplicates within each individual collumn.
Then tried to set up a relationship between one date collumn in the SlicerTable, with one of the other tables.
I get an error saying there duplicates in both tables.
This is true for one table. BUT NOT for the SlicerTable. There are only two calendar dates in it.
July 16, 2010
Welcome to our forum.
I cover how to set up relationships for this in my Power Pivot course. The key is to create dimension tables for each of the columns you require. The dimension table will have a unique list of items for the field you want to create the relationship between. It sounds like your Slicer table has duplicates for the field you are trying to use as the relatable column.
You then need to ensure that the PivotTables use the fields from the dimension tables in the row/column labels. Only the value fields should come from one of your 3 'data tables'.
Hope that points you in the right direction.