Several Sliders Filtering one table

[JoseDavidM]

Hi. i am trying to use the values selected in several sliders to filter one table. example.

Table 1 

Code	Name
1	A
2	B
3	C
4	D
1	A
2	B

Table 2

Code	Name
5	E
6	F
7	G
5	E
6	F

Table 3

Code	Name	Location
1	A	Location 1
2	B	Location 1
3	C	Location 2
5	D	Location 2
6	E	Location 2
7	F	Location 2

I have created the Slider 1 with the field Table1.Code and Slider 2 with the Field Table2.Code and i need to filter the Table 3 using both values in slider 1 and 2, for example: if i selected in slider 1 = 2 and in Slider 2 = 3 i need that Table 3 only shows 2 and 3 Codes.

any idea?

[Ashish_Mathur]

Hi,

I am quite confused.  For your limited question/requirement, what is the use of Table1 and Table2.  Just use Table3 to build your slicer and visual. 

[JoseDavidM]

it maybe make more sense if a show the actual data

in the image below Slicer 1 is used to filter info in Slicer 2 that at the same time filter Slicer 3 an so on.

each value in each slicer contain more detail information that doesnt fit in this page, for that reason a create another page to provide the user with those details (see image below)

but i still have some issue trying to show all the data in one page, especially because the table doesnt clean up after a select new value on the page 1 slicers

i'm looking for a better way to show those details

this is my table and relations structure. tables above contain the general information and the relation beetwen each slicers in page 1 and tables below contain the details of each value selected

my issue is that if no value is selected in the slicers all values are shown on the detail page

[HashamNiaz]

Hi @JoseDavidM  !

Now with your modified requirement, you will need to create a new table Table 4 by merging Table 1 & Table 2. 

You will need to connect Table 3 to Table 4 using 1-Many relationship based on [Code] Column, and set the cross filter direction to [Both].

You can choose filter values from Table 4.

Hope this will help you solve the issue.

Regards,

Hasham

[HashamNiaz]

Hi @JoseDavidM !

Please share your data model diagram how you have connected these table through relationship.

You can connect Table1 to Table3 using 1-Many relationship based on [Code] Column, also you need to connect Table2 to Table3 using 1-Many relationship based on [Code] Column.

Please check that filter direction is set to single. Hope this will solve your requirement.

Regards,

Hasham

[JoseDavidM]

Thank you for the answer, i am getting an error: "The Cardinality that you have selected is not valid for this relation"

[HashamNiaz]

Hi @JoseDavidM !

Table1 & Table2 doesn't hold unique [Code] values ?

[JoseDavidM]

No, only table 3 have unique values (my mistake)

[HashamNiaz]

But in the sample data snapshot you it shows repetive values for column [Code] in table3.

[JoseDavidM]

My mistake, check the post again