Forum Discussion

wsgr_BI's avatar
wsgr_BI
New Member
5 months ago
Solved

Sticky Filters

Hello,   I know we can filter through the slicers and we can filter through tables but through tables it is only for exploration. If you have 2 tables and you click on 1 then it will filter on the ...
  • Murtaza_Ghafoor's avatar
    5 months ago

    wsgr_BI 

    This behavior is built into Power BI’s cross-filter interaction model, which is why users often need Ctrl + click to select multiple values.

    You can control this through edit interaction option.
    for example

    Steps:

    Select Table 1

    Go to Format → Edit Interactions

    Choose Filter or None for other visuals.

    However, this does not make it behave like a slicer, it only controls which visuals are filtered.

     

    Proposed Solution:

    Replace the table with a formatted slicer

    Use horizontal or tile slicers

    Make them visually similar to tables

    This gives users the same filtering experience without needing CTRL click.

     

    If this helps, ✓ Mark as Kudos | Mark as Solution| Help Others

  • danextian's avatar
    5 months ago

    What you’re trying to achieve isn’t currently possible. Unlike slicers, the other visuals in Power BI do not retain previous selections when you click from one data point to another; the new selection simply replaces the previous one unless the Ctrl key is used to create a multi-select. Because of this behavior, there’s no built-in way to persist multiple selections across regular visuals through simple clicks alone. The practical options are either to introduce additional slicers to control the filtering more explicitly, or to communicate to report users that this is a current limitation of the tool and that there isn’t an alternative method available to change this interaction behavior.