The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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! |
|
User | Count |
---|---|
14 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
19 | |
13 | |
8 | |
5 |