Forum Discussion

Advocate I

7 years ago

Table Visual - Prevent unfiltering on row click

I have a report with a pie chart and a table. Selecting a slice of the pie chart filters the table as expected. However, even with interactions disabled from the table, when I click on any record i...

Advocate I

7 years ago

Thanks for the reply. Ctrl-click does preserve the position but does not trigger the data selected event so it’s just a partial solution. I think this may just be a limitation of Power BI and additional functionality is needed to preserve filters on table clicks.

witaing
Microsoft Employee
7 years ago
I ran into the exact same issue and I'm surprised this hasn't been more significant of a complaint before. I have the table filtered perfectly down to how I want it, but then when I click on a row it messes everything up. Even when I have all interactions with other visuals turned off.
- StuartSmith
  Power Participant
  7 years ago
  I posted a similar question https://community.powerbi.com/t5/Desktop/Table-filter-resetting-when-table-row-selected/m-p/699528/highlight/false#M337556 and got the same not very helpful response of clicking ctrl. Its fine if you know this, but users using the report...
- dcorentin
  Advocate I
  6 years ago
  Im having the same issue and i also think it is a significant Issue, what can we do to amplify the message? How are people getting beyond this problem?
  - witaing
    Microsoft Employee
    6 years ago
    The only workaround right now is to hold ctrl while you click :/