Forum Discussion
Make visual affect slicer
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.
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.
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=powerbi-desktop
3 Replies
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.
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=powerbi-desktopDepending 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
