Make visual affect slicer

[tiavinag]

Good morning.
Slicers are filtering visuals. But visuals can't affect slicers.
For example, I have a product category slicer and a bar chart showing total price per category. I can filter the bar chart using the slicer. But I also want that if I click a bar category, the slicer get filtered too.
How can I do that ?
Thank you for your help.

[aymantm · Accepted solution]

The default behavior is that each visual filters the others. If you click on a bar this should filter the slicer too by default. If this is not the case you can select the bar chart from Power BI desktop and go to format tab, then turn on the Edit interactions command, select the filter icon around the slicer.

[MarkD1722]

Depending on what you are looking for, could you possibly replace the slicer with a simple table which can act similar to a slicer?  Tables can affect other visuals and be affected by other visuals.  You could use the same table that is affected by a slicer to then select rows that will crossfilter accordingly.  It's not a user-friendly as a slicer, but I think it could get the job done depending on what you are trying to do.  Focus mode would be most helpful if you don't have a lot of space for the "slicer table."

Thoughts?

Mark

[PijushRoy · Accepted solution]

Hi @tiavinag 

Adding to @aymantm comment,
please find the step by step guide to control filter interaction between two or more visual
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

[aymantm · Accepted solution]

The default behavior is that each visual filters the others. If you click on a bar this should filter the slicer too by default. If this is not the case you can select the bar chart from Power BI desktop and go to format tab, then turn on the Edit interactions command, select the filter icon around the slicer.