Differences between two tables

[Tob_P]

Imagine the below with a direct relationship between the two tables...

Table 1		Table 2		Slicer
Owner		Owner		Owner
Name A		Name A		Name A
Name B		Name B		Name B
Name C		Name C (North West)		Name D
Name D		Name C (North East)		Name E
Name E		Name D
		Name E

Table 1 holds information relating to Accounts, Table 2 is essentially a lookup/bridging table that references the rest of the tables in the report and is pretty much essential. The Accounts table holds no other information in it that an inactive relationship could be created on. When adding a slicer to the report using the fields in Table 2 (which is how I need to slice), then obviously Name C isn't appearing.

I'm trying to think of an obvious way to get those output in the slicer. Any suggestions of help?

[v-chenwuz-msft · Accepted solution]

Hi @Tob_P ,

Is that you create a relationship like the following image?

If you do like this and the slicer will contain "Name C".

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.