Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Slicer not affecting the table, it shows empty value for table

In my Power BI dashboard, Slicer, Table 1 and Table 2 , I have slicers Claue: A, B, and C. When I select a value C from slicer , it filters Table 1(e.g., C1, C2, C3,C1.1, C2.2, C3.3), After select...
Need Help
Show and Tell
Tips and Tricks
sandeepsai's avatar
sandeepsai
Icon for Advocate I rankAdvocate I
1 year ago

Hey 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.