Forum Discussion
Table filter resetting when table row selected.
- 7 years ago
I eventually ended up removing the map visual as wasnt working how i wanted it to.
Anyone found the solution? It is year 2022 (3+years since issue first reported) and I still can't find how to approach it. Holding Ctrl key is not an option - when reports are used by thousand users you can't expect them to intuitively use Ctrl, no you can put instructions on every report page. There has to be an option to enforce one-way interactions for a visual.
I also searched for months and could not find a direct solution to this issue, but I found so far the following two workarounds. Neither of them are perfect, but if you absolutely need to find something for this issue, this may still work for you:
1) If available, use drill-down on the first visual (e.g. map in the above context) that cross-filters to the table. The drill-down will have an effect of "locking" the filtered state in the second table and prevent from resetting it. The limitation is that users need to know how to use drill-down and drill-up, and the drill-down cannot be kept to "on" by default (i.e. it always shows as “off” when reports are loaded the first time).
2) Download and use the following table visual (also from Microsoft) instead of the standard table:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380796?src=office
Strangely and compared to other tables I tried, this one does not reset its filter even after clicking on an entry.
The limitation is that this table is not a conventional table (it is a ranking table) and options are very limited (e.g. no possibility to change the font, font size, no line wrapping, cannot remove the first “Rank” column), but by hiding parts that are not needed, it provides at least a possible way.
- Anonymous1 year agoNot applicable
Hi, it's been a long time and still the issue remains there. The link to the table you shared is not available anymore, can you share the name of the visual?
thanks!- leekt1 year agoNew Member
Hi,
It is called "Table Sorter". I noticed that it is still possible to download it through the following page:
https://pragmaticworks.com/blog/power-bi-custom-visuals-table-sorter