cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

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. 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Gingerclaire_,

 

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:

laurinyeczm_0-1595930782986.png 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.

View solution in original post

6 REPLIES 6
Solution Sage
Solution Sage

Click the following icon. 

Karlos_0-1595925108304.png

 

This will give you the slicer visual, Then add/drag "Products" to the values field. 

Karlos_0-1595925272046.png

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?

Super User IV
Super User IV

@Gingerclaire_ ,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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi @Gingerclaire_,

 

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:

laurinyeczm_0-1595930782986.png 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.

View solution in original post

Super User II
Super User II

@Gingerclaire_ ,

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

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn

Please take a quick glance at newly created report:
My Report
Community Support
Community Support

Hi @Gingerclaire_ ,

 

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors