Forum Discussion
PowerBI Filtering
I am new to PowerBI so this might be a quick fix - I just can't see it.
I have one set of data for products manufactured in a bar graph. Each product has a set of features (about 5 or 6 per product). With all the data there will be about 6 products but 30+ features making the bar graph look crowded.
What I want to do is filter to product 1 then only see the 5/6 features associated with it. Currently it's only shading in the columns but leaving the ones with no data.
Hi Anonymous,
You can choose which visual you want your slicer to control. To to this click on your slicer, go to the Format tab, and on the left you can see the Edit interactions button. Click on that and then two icons will appear above all the visuals:
If the left one is selected on a visual it means that your selected slicer controls that visual if the right one is selected it doesn't. Select the right one for all visuals except for the one you want your slicer to control.
6 Replies
Hi Anonymous,
You can choose which visual you want your slicer to control. To to this click on your slicer, go to the Format tab, and on the left you can see the Edit interactions button. Click on that and then two icons will appear above all the visuals:
If the left one is selected on a visual it means that your selected slicer controls that visual if the right one is selected it doesn't. Select the right one for all visuals except for the one you want your slicer to control.
Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.Anonymous ,
If you want Slicer only interact with your one bar graph so Take the Product and Feature in separate Slicer and use the Edit Interaction feature which enable these Slicer to work only with your bar graph and inactive for rest of the page.
https://radacad.com/control-the-interaction-in-power-bi-report
Hi Anonymous ,
Check the document about slicer in power bi.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
And the document about interactions between visuals.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Best Regards,
Jay
