Forum Discussion

iwf's avatar
iwf
Helper I
8 years ago
Solved

Data Slicer from second level table

Hi,

can anybody help me with slicer. I have first table with data. First column is respondent email. In second table I have all customers emails and company ID. In third table I have all companies.

 

What I want to is use values from company table to slice the respondents. There are relations 1:* between the tables in the responded – customer – company.

 

I am able create slicer only for Client – Respondent and Client – Company. Is there any possibility to slice Respondents based on Company values?

 

Thank you

4 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    Hi iwf,

     

    Here I made a sample and created the relationships between tables as below. Here the cross filter direction should be both as you want to slice Respondents based on Company values.

     

     

    Then we can achieve your goal.

     

     

    For more details, please check the pbix as attached. If it doesn’t meet your requirement, kindly share your sample data to me.

     

    https://www.dropbox.com/s/irmqzxcwz492r4z/relat.pbix?dl=0

     

    Regards,

    Frank

    • iwf's avatar
      iwf
      Helper I
      8 years ago

      Frank,

       

      thank you for answer. I see, that you have Compamy ID in all 3 tables. That is not my case. I have:

       

      Table 1

      Respondent ID, respondent email, Answers

       

      Table 2

      Client email, ParentCompany ID etc(client charakteristics)

       

      Table3

      Company ID, Company Name (account charakteristics)

       

      I know, that I can merge all 3 tables together and get Company ID into respondent table. I solved the problem that way, but this way is not good while refreshing the date (merge 3 table) is time consuming. I thought that if I relate the tables with this way - respondent email - client email + ID company - Id company + name I can avoid to merge tables into 1 super table.

      I have the answers from survey web page, the other two table are from MS CRM, so the client table and company table are huge (with many related entities within)