Forum Discussion

JoseDavidM's avatar
JoseDavidM
Icon for Helper I rankHelper I
5 years ago

Several Sliders Filtering one table

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

 

Table 1 

CodeName
1A
2B
3C
4D
1A
2B

 

Table 2

CodeName
5E
6F
7G
5E
6F

 

Table 3

CodeNameLocation
1ALocation 1
2BLocation 1
3CLocation 2
5DLocation 2
6ELocation 2
7FLocation 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?

9 Replies

  • 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's avatar
      JoseDavidM
      Icon for Helper I rankHelper I

      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

       

       

  • 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's avatar
      JoseDavidM
      Icon for Helper I rankHelper I

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

  • 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