Data Slicer from second level table

[iwf]

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

[v-frfei-msft]

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]

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)

[v-frfei-msft · Accepted solution]

Hi @iwf,

Again I made a sample as your description, and the relationship between tables is like the picture as below.

Then we can slice Respondents based on Company values.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/dzw94ozz7vmjfqb/relat2.pbix?dl=0

Regards,

Frank

[iwf]

Hi,

it is curious, now it work also with my pbix. I think it had something to do with cross filtr direction or somethinkg.