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

[Anonymous]

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 selecting a value in Table 1 (e.g., C1), it filters Table 2 (e.g., Table 2 shows only data for C1.a,C1.1a).
If I select C1.1a in table 2 it filrer table 1.

However, when I change slicer C to slicer B, Table 2 resets (as expected), but Table 1 does not reset it becomes empty based on the new slicer selection.
When I checked table 1 filter and slicier on this visual by clciking filter icon it has included1 (filter of table2)
How can I ensure that when I change slicers (from C to B), Table 1 also updates correctly to reflect the new slicer choice?

[sandeepsai]

Try to use sync slicer option as i mentioned in the above reply.

[Uzi2019]

Hi @Anonymous 

yes your previous seletion will be remain on the table. Every time you have to reset all the filter before switch to new slicer selection.

just add one button and on action reset all filters. It will reset your whole report.

I hope I answered your question!

[Anonymous]

Thanks for the solution. So their is no other option apart from clear button, because once we change the slicer it should reset to actual context right.

[Uzi2019]

Hi @Anonymous 

The selection on slicer you are seleting then on table you are selecting value to highlight or
filter other value. 

so you made 2 selection . upon resetting or changing the 1st filter it will check for the changes you have made for selecting the filter and highlighted part of previous table selection. 

Both condition are not matching that's why giving you blank value.

you must clear all the selection before you making a new selection. it will simplify your data nd just adding a single one more step to select your row in the table...

I hope I answered your question!

[Uzi2019]

Hi @Anonymous 

You can simply check your filter property of a table by checking the filter option.

you will understand why data is not coming based on condition applied on that table.

beacuse both the condition will not match together with you required data.

I hope this give you idea of your situation.

[sandeepsai]

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. 

[Anonymous]

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.