Forum Discussion
Using a filter to reflect three visuals coming from 3 queries
if i defined relationship, there is no many to many within drop down.
but i created a table 'AgeType' with the values and added the relationship for all the three tables and it worked.
Thank you so much
Ronak
v-juanli-msft these values are for customers, vendors. but they exist for all of them..
i want filters like:
001_030
031_060
061_090
091_120
and GT121
so if i click on any of them, they should show that filter for all the three visuals.
Please let me know the solution.
As long as you have a valid relationship between the three tables you can add a slicer for the age_type column and it will update all visuals.
I loaded three separate tables with the columns customer, age_type and total and then added relationships via customer.
The relationship can exist between any column that has matching data, so you could set it up directly to the age_type column as well.
Once you have your relationships defined you can then add the slicer using any of the age_type fields and all three visuals should update based on the slicer.
Thanks,
Jerica
Hi jericacoleman ,
I tried creating relationships between the three tables, but then it gives me the error that the column should have unique values.
tried with all the three and they gave me this error.
What other way can this be implemented.
Thanks in advance
Anonymous
When you are creating your relationship what is the cardinality set to?
If you have it set to Many to Many (*:*) you should not receive the unique values error.
Otherwise, to avoid a unique values error you can create a separate table to serve as a reference table for your Age Types. I created a table within Power BI with just the column Age Type and entered the unique values you had listed. The relationships were auto-detected to match the other 3 tables, if not done automatically you can set it up manually and then I set-up the slicer based on the Age Type column in the created table.
if i defined relationship, there is no many to many within drop down.
but i created a table 'AgeType' with the values and added the relationship for all the three tables and it worked.
Thank you so much
Ronak