Forum Discussion

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
4 years ago
Solved

Differences between two tables

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's avatar
    v-chenwuz-msft
    4 years ago

    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.

1 Reply

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.