Show unfiltered data on a table!

[VROliveira]

Hi, guys!

I need a little help.

I have a project with one data source (excel file) with some names and dates. I want to show two tables on my dashboard, where:

Table 1: Shows names filtered by date.

Table 2: Shows unfiltered names.

How could I do it?

Thanks for helping!

Printscreen:

[Anonymous]

Hello-

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

[VROliveira]

Jared, thanks for your answer! But I need only unfiltered data, not all of them!

[Anonymous]

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

[VROliveira]

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!

[Anonymous]

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