Forum Discussion
Click and filter instead of grey out
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?
5 Replies
- lbendlin
Super User
Change the default UI behavior from Cross Highlighting to Cross Filtering.
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?
