Forum Discussion
Slicer not affecting the table, it shows empty value for table
Advocate IHey Anonymous
Follow the below steps:
Verify that the relationships between slicers and the tables are set up correctly. Confirm that the data types for slicer fields and table fields are consistent. Review and adjusted interactions for the slicers. Check Filters and Look for active filters affecting Table 1. Check for any hidden filters or transformations that might impact data display. Conduct tests with various selections but issues persist.
If you haven’t resolved the issue yet, here are a few extra steps to try:
- Open your Power Query Editor and select one of the slicer visuals in your report.
- Click on the View option in the ribbon, then select Sync Slicers.
- You’ll see an option called Additional Filters where you can give a group name to a specific slicer.
- Repeat this for the other slicers, giving them the same group name in the Additional Filters of the sync slicer. This should sync all the slicers together.
By following these steps, you should be able to resolve the issue!
Please mark it as a solution, it will help more users with the same problem, thank you in advance.
Thanks for response.
No hidden filter in that page. while clicking Table 2 value it filters Table 1.
So if I change slicer value to A, it applied to table2 but table 1 become empty while checking table1 filter applied it shows included filter as table 2 selected value.