Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
dofrancis3
Helper III
Helper III

Filter Slicer

Dear Colleagues;

 

Please i need your help!

 

As you can see i have Two bar charts and a Slicer in the same page

So, I would like to apply the filter only for Bar chart_1 when i'll select the country in the Slicer. (only Bar chart_1 need to change the values based on my selection).

 

Thnak you for your assistance. 

 

dofrancis3_0-1739406937050.png

 

 

1 ACCEPTED SOLUTION
bhanu_gautam
Super User
Super User

@dofrancis3 

Click on the slicer that you want to use to filter the data.

 

Go to the "Format" tab in the ribbon and click on "Edit Interactions". This will show interaction options for all visuals on the page.

 

Set Interaction for Bar Chart_1: For Bar chart_1, ensure that the filter icon (a funnel) is selected. This means that the slicer will filter this chart.

 

Disable Interaction for Bar Chart_2: For Bar chart_2, click on the circle with a line through it (no filter icon). This will disable the slicer from affecting this chart.

 

Once you have set the interactions as desired, click on "Edit Interactions" again to turn off the interaction editing mode.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

2 REPLIES 2
powerbidev123
Responsive Resident
Responsive Resident

Hi @dofrancis3 , For this to happen go you will have to make your slicer work as per the filtration for only bar chart1.

Click on your Country slicer then Go to Format-> Edit interactions and choose filter option for bar chart1 and set None for bar chart2

 

 

 

bhanu_gautam
Super User
Super User

@dofrancis3 

Click on the slicer that you want to use to filter the data.

 

Go to the "Format" tab in the ribbon and click on "Edit Interactions". This will show interaction options for all visuals on the page.

 

Set Interaction for Bar Chart_1: For Bar chart_1, ensure that the filter icon (a funnel) is selected. This means that the slicer will filter this chart.

 

Disable Interaction for Bar Chart_2: For Bar chart_2, click on the circle with a line through it (no filter icon). This will disable the slicer from affecting this chart.

 

Once you have set the interactions as desired, click on "Edit Interactions" again to turn off the interaction editing mode.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.