Forum Discussion
Slicer
Hi, I'm fairly new to working with Power BI. I was able to create multiple visiuals and slicers, however, the slicers are not working properly. I have two slicers and two tables, i need the slicers to work independently and together to filter my visuals. I checked my connections, i tried to sync the slicers as well and even use the advanced option but the the filter options in the slicers do not filter both visuals correctly. Not sure what else today, any help/suggestions would be greatly appreciated
14 Replies
Anonymous - Are you talking about being able to select from each slicer (selection item) as needed; CTRL + Left Click? Possibly you can share more about what you are experiencing.
ChrisMendoza wrote:Anonymous- Are you talking about being able to select from each slicer (selection item) as needed; CTRL + Left Click? Possibly you can share more about what you are experiencing.
ChrisMendoza Somewhat, I created two slicers to filter multiple tables. The slicers will filter each other but not both tables.
Hi Anonymous ,
I created some data:
Table：
Table2：
The [date] column of Table and the [group] of Table2 are used as slicers, and they will affect each other.
Here are the steps you can follow：
1. You can select the slicer group and open Format-Edit interactions.
2. Click on the circle that appears in another slicer.
3. Select the slicer date, open Format-Edit interactions.
4. Click on the circle that appears in another slicer.
5. So that the two slicers will not affect each other.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
