Keep filters when selecting datapoints in different tables

[Anonymous]

Hi everyone,

I am making a report with the following tables:

ProjectList

Project ID	Project name	Project Owner
1	Project X	John Doe
2	Project Y	Jane Doe

And

StatusUpdates

Project ID	Date	Update
1	20/11/2021	Fixed issue 1
2	22/11/2021	Fixed issue 2
1	21/11/2021	Fixed issue 3
2	24/11/2021	Fixed issue 4

The relationship between the tables filters in both directions on Project ID. If I click on project 1 in the first table, it only shows me update 1 and update 3 in the second table, which belong to this project, so this works. However, when I click the first project in the second table it shows me the related project, but the Update-table resets and it shows me all the values again (greyed out). Is there a way to keep the first 'filter' which is the one initiated by clicking a value in the first table?

Thanks

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

When you click on the data on the table, you will get the filtered data, but this is only a temporary view. Every time you click on the data, your filter conditions will be reset. This will not combine the filter conditions you have clicked multiple times. If you want to keep the previous filter, an easy way is to use a slicer.

Best Regards,
Community Support Team _ Zeon Zheng

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