topic Re: Filter Slicer in DAX Commands and Tips

Filter Slicer

dofrancis3 — Thu, 13 Feb 2025 00:36:25 GMT

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.

Re: Filter Slicer

bhanu_gautam — Thu, 13 Feb 2025 03:36:03 GMT

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.

Re: Filter Slicer

powerbidev123 — Thu, 13 Feb 2025 03:37:43 GMT

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