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

Question

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?

uzi2019 · Answer

Hi&nbsp;Anonymous&nbsp;
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.
&nbsp;
just add one button and on action reset all filters. It will reset your whole report.

&nbsp;
&nbsp;
I hope I answered your question!
&nbsp;

sandeepsai · Answer

Hey&nbsp;Anonymous&nbsp;&nbsp;Follow the below steps:&nbsp;Verify that the relationships between slicers and the tables are set up correctly.&nbsp; Confirm that the data types for slicer fields and table fields are consistent. Review and adjusted interactions for the slicers. Check Filters and&nbsp; 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.&nbsp;If you haven’t resolved the issue yet, here are a few extra steps to try:&nbsp;Open your Power Query Editor and select one of the slicer visuals in your report.&nbsp;Click on the&nbsp;View&nbsp;option in the ribbon, then select&nbsp;Sync Slicers.&nbsp;You’ll see an option called&nbsp;Additional Filters&nbsp;where you can give a group name to a specific slicer.&nbsp;Repeat this for the other slicers, giving them the same group name in the&nbsp;Additional Filters&nbsp;of the sync slicer. This should sync all the slicers together.&nbsp;By following these steps, you should be able to resolve the issue!&nbsp;Please mark it as a solution, it will help more users with the same problem, thank you in advance.&nbsp;&nbsp;

anonymous · Answer

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.

anonymous · Answer

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.

uzi2019 · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
The selection on slicer you are seleting then on table you are selecting value to highlight orfilter other value.&nbsp;
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.&nbsp;
&nbsp;
Both condition are not matching that's why giving you blank value.
&nbsp;
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...
&nbsp;
I hope I answered your question!
&nbsp;
&nbsp;

Forum Discussion

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

7 Replies

Related content

Slicer panels affecting bookmarks

Slicer affected by other slicer

make slicer only affect one table

CALCULATE with REMOVEFILTERS still affected by slicer

Make visual affect slicer