Forum Discussion
Show unfiltered data on a table!
The best way to do this would be to turn off interactions for that visual in “Edit Interactions” on the top bar on the top left. Filters will then not affect Table 2.
Jared
Jared, thanks for your answer! But I need only unfiltered data, not all of them!
Hello, sorry I am a little unclear. When you say it should be unfiltered data and not all data, do you mean it should be all data in the table, but just not the data that is being filtered? I might need a little more explanation.
Jared
Yes, that's it! If my source is A, B and C, and Table 1 is showing up A, Table 2 must show B and C. Sorry for the poor explanation, hope I did it right now!
Ah, I see. Interesting question. Does it need to be in 1 slicer? Because one workaround I can think of is to create 2 slicers, put one above each matrix/table and edit interactions so that the slicers only affect the one table. It might be an extra click or 2 for the end user though.
The tough thing you'll run into is that once the data is filtered out in your slicer, its as if it does not exist in the data set anymore! Sorry I could not be of more help....