Forum Discussion

VT's avatar
VT
Regular Visitor
9 years ago

Double Filter

Hello 

I have created 3 tables

 

Table 1: Information related to Participant: Name, Country, Language Spoken, Unique Participant ID

Table 2: Information related to Courses: Course Name, Unique Course ID

Table 3: Curriculum Taken: Unique Curriculum ID, Unique Course ID from Table 2, Unique Participant ID from Table 1

 

So Table 3 & 1 has 1 to Many relationship & Table 3 & 2 has 1 to Many relationship 

 

How do I create double filer.  I have Visual's of a Map.  When I click on a country I get a visual of folks who have taken courses in that country long with languages they speak.  If I need to create a double filter to see...Person with German Language, with Course Name XYZ.....  display the list of Participant name.  How do i do that. 

 

Thanks 

VT

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi VT

     

    In your scenario, "Slicer" and "Table" visual would be enough. We can use "Edit interactions" if we want the slicers work independently.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi VT,

     

    Could you please mark the proper answer if it's convenient for you? That will be a help to others.

     

    Best Regards!
    Dale