Forum Discussion
Sticky Filters
- 5 months ago
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 exampleSteps:
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
- 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.
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