Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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.
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
@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
@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.
Click the following icon.
This will give you the slicer visual, Then add/drag "Products" to the values field.
This should allow you to quickly filter by product.
This will filter all the graphs on the page not just the features graph that I want. I still can't see an option to do this?
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.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |