Looking for advice on relationships of pivot tables and general good practice

[MyWeeLola]

Good morning

I have been given 2 legacy tables to merge and create a dashboard report.

The tables have merged sucessfully, however what i am now looking at is a lot of delimited data in a couple of columns

I have added an index field to the merged table (tblMain)

I have created 2 pivot tables based on the delimited columns

I have created a date table and created a custome slicer to allow the user to select time periods.

My date table connects to the now 3 tables, with seperate one to many connections

I originally limited each pivot table to contain columns of Index, date and attribute and value.

However, now as I progress with client requests, I find myself having to provide slicers for different data which is contained within the various tables, which then necisitates adding different fields to each slicer inorder to keep the report data valid. I am sure i am doing this incorrectly. My end data report is correct based on values, however im sure you have better advice for me.

Here is what I have. In this example, the customer has now asked me to created a slicer for email.

 My email column appears in the main table, Do I add the column to each pivoted table and then add an email table and connect them up as a 1 to many?

I await some good advice 🙂

Lola

[MyWeeLola · Accepted solution]

ok i got it. feed the general slicers into the main table, then connect the main table using 1 to many, using the index fields.. I knew you were all an inspiration!!!

[v-linhuizh-msft]

Hi @MyWeeLola ,

I'm glad to hear you share your solution, can you accept it as solution, it will also help other users in the community with similar problems to solve them faster, thanks for your contribution!

Best Regards,
Zhu
Community Support Team