Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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! |
|
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 9 | |
| 8 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 23 | |
| 14 | |
| 10 | |
| 6 | |
| 5 |