topic Re: Click and filter instead of grey out in Developer

Click and filter instead of grey out

Anonymous — Fri, 02 Dec 2022 23:44:12 GMT

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?

Re: Click and filter instead of grey out

lbendlin — Sat, 03 Dec 2022 17:13:33 GMT

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

Re: Click and filter instead of grey out

Anonymous — Mon, 05 Dec 2022 01:54:36 GMT

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?

Re: Click and filter instead of grey out

Anonymous — Mon, 05 Dec 2022 02:14:34 GMT

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.

Re: Click and filter instead of grey out

v-jianboli-msft — Tue, 06 Dec 2022 07:49:52 GMT

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.

Re: Click and filter instead of grey out

Anonymous — Tue, 06 Dec 2022 14:48:24 GMT

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.