Click and filter instead of grey out

[Anonymous]

I have two tables on Power BI. First one is aggregation(Minute to Month level) of second. When I click on one row in first table, entries in second are filtered and reduced as per clicked record. Subsequently when I click on a row in second table, that row gets highlighted and other rows are grayed out. But I wanted the other rows to be filtered out(removed) and not show in the second table. Only clicked row to show. How can we achieve this functionality?

[lbendlin]

Change the default UI behavior from Cross Highlighting to Cross Filtering.

[Anonymous]

Sorry, but it did not help. Click on the second table still highlightes the selected row and all other rows are faded out and sorted. The problem that it causes that because it is minute level data there is huge number of rows in second table and it appears as if the row was not selected as it is not visible on the screen. Filtering will show only that row and avoid the confusion. Hence wanted to show only that single row using filtering on click. Any other suggestions?

[Anonymous]

As seen in the pic, I have click on Group "Two" on both the visualizations. But in second only mite level entries show faded out entries for Group "One". I just want one clicked entry of group "Two" to be seen in second table.

[v-jianboli-msft]

Hi @Anonymous ,

From what I understand, you can't filter your current visual by just clicking on it, so if you want to filter both visuals, consider creating a Slicer for the Group field.

For more details, please refer to:

Change how visuals interact in a report - Power BI | Microsoft Learn

Slicers in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

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

[Anonymous]

Sorry, creating slicer is not a acceptable solution. Think of this, we have hundreds of minutes in the second table. how can one add a minute level slicer for such huge data? It is not a good user experience.