Forum Discussion
Filter All Pages using an Identical Column from Multiple different Tables
Hi All, please excuse my ignorance, I am very new to Power BI and need some help with filtering. As you can see from the image below, I have around 20-30 tables (currently unrelated). However, every table has a column called Element consisting of the same values (Value 1 = A - Value 2 = B).
I want to filter all pages on the report based on the value in this column, but I want to be able to have one filter that filters all Element columns in all tables. Is this possible?
Hi CaveOfWonders ,
You can create a new table and de duplicate "element", and then use "element" to create relationships with other tables. Then apply the new "element" to the report level filter.
Table 2 = DISTINCT(SELECTCOLUMNS(Sheet1,"element",Sheet1[element]))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
I did not get it. But you should create a common Element dimension and join all table elements with this.
Refer
https://docs.microsoft.com/en-us/power-bi/guidance/
Hi CaveOfWonders ,
You can create a new table and de duplicate "element", and then use "element" to create relationships with other tables. Then apply the new "element" to the report level filter.
Table 2 = DISTINCT(SELECTCOLUMNS(Sheet1,"element",Sheet1[element]))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
