how to make a slicer for two table not a relationship.

[Anonymous]

Hi Everyone

I have a case but I cannot descrip tinny detail because my english not well.

I have two table:

table1:

Project	BA	Code	Test
Project 1	MrA	MrB	MrC
Project2	MrA	MrB,MrD	MrC
Project3	MrB	MrD	MrE

Table2

Name

MrA

MrB

MrC

MrD

MrE

I want to creat a slicer by name of table 2 which controls table1 when I choose.

Ex:

I choose Mr A,table 1 shows rows which contains Mr A, as below:

Project	BA	Code	Test
Project 1	MrA	MrB	MrC
Project2	MrA	MrB,MrD	MrC

Many thanks !

[TheoC]

Hi @Anonymous 

Please follow steps below.  I also changed "BA" in Table1 to "Name" to match:

1. Create a relationship between Table1 and Table2.  Table2[Name] to Table1[Name] being one to many relationship.

2. Go to Visualisations and select Table visual.

3. Drag Table2[Name] into the Table visual as per below.

4. Your Table visual will look like this:

Hope this helps! Please mark as solution if it is correct 🙂

[Anonymous]

Thanks for help but it's incorrect. I want to create a slicer by column Name of table 2 which can control table2

[TheoC]

@Anonymous, if you follow my earlier steps, all you need to do is get the Slicer visual and use Table2[Name] in the visual and you can then slice and dice 🙂

[Anonymous]

It's incorrect as i want.

I have two table, table 1 and table 2

I create one table visual as table 1 and one slicer visua as below

So, I want slicer can control the row of table visual.

Ex.

i choose mr.A in slicer--> show row 1,row2 (project I,II)

I choose MrD --> show row2,3 (project II and III)

[TheoC · Accepted solution]

@Anonymous, if you want to filter by Table2[Name], you need to structure your data in Table1 in such a manner to enable this.  Please do the following:

1. Create Calculated Column called "SearchField" like below

2. Create a Measure in Table1 as follows.

3. Output is as below:

The other way to do it is in Power Query, pivoting all of the various columns with Names into a single column, then using the 1 to Many relationship beween Table2[Name] and Table1[NewColumnFromPowerQuery].  In all honesty, I'd go with Power Query because it's far cleaner.

Cheers,
Theo

[Anonymous]

Thanks my friend! 

[TheoC]

@Anonymous a pleasure! Glad we were able to get the outcome you need!

All the best 🙂

[Anonymous]

Thanks for help but it's incorrect. I want to create a slicer by column Name of table 2 which can control table2