Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
Solved! Go to Solution.
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.
Proud to be a Super User! |
|
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
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.
Proud to be a Super User! |
|
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
12 | |
10 | |
10 | |
8 |
User | Count |
---|---|
16 | |
15 | |
14 | |
12 | |
10 |