Filter by the cell of a table and not the row

[Anonymous]

 Hi guys!

I come to you for help as I can't figure out how to achieve to filter a whole page from the value of the cell of a table, and not the row.

Indeed I have two tables on my page : 

The first table looks like that :

Customer ID, country, Customer sector, turnover

  1                ,  France, Aerosptial           , 100 000

  2                , Mexico, Food                   , 50 000

etc

The second table gives information about the contracts we have with the various customers, example :

Customer ID, Contract ID, contract start dates, Customer sector

1                  , C123           , 01/01/2021           , Aerospatial

3                  , C668           , 02/03/2021           , Chimicals

etc.

What I would like to achieve is to filter the second table by a customer ID I clicked on in the first table. For example on the first table I click on Customer ID = 1 and I see only the contract of this customer in the second table. But what happens now is that the whole row filters the second table, so in my second table I see indeed Customer ID = 1 but also all customers in France and Aerospatial sector (all row elements filter).

I know that I can put a slicer on Customer ID but I already have one and in my user experience it would be far better to achieve something similar to filtering by the cell customer ID of the first table. So you understand the user experience i am looking for : I already have several filters that helps leading analysis on the first table, and I want then my user to choose the customer they want to dig in (see the contracts) among the result of the first table, so cliking on the cell would be perfect...

If you have any idea about how to achieve such result that would be great!! 😄

Thank you very much!

Best,

Léa

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You need to create a relationship between the two tables. Then click on the field in the visual to filter. For details, please refer to Cross-filter and cross-highlight visuals.

Best Regards,

Stephen Tao

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

[mwegener]

Hi Lea,

can you share a screenshot of the data model?