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