Forum Discussion
Solved
slicer for multiple tables
I have 3 different tables in the powerBI. However, there is also 3 columns that are common between the three tables. Table 1: column X ; P; N; Year; Site; Location Table 2: column A; Z; Year;...
If you create a dimensions for year, site and location and setup a 1 many relationship to your tables you can use the dimensions in the slicers.
If there are different locations between the tables, for example, you can use the following the make the dimension
Distinct(
Union(
Distinct( table1[location] ),
Distinct( table2[location] ),
Distinct( table3[location] )
)
)
If you create a dimensions for year, site and location and setup a 1 many relationship to your tables you can use the dimensions in the slicers.
If there are different locations between the tables, for example, you can use the following the make the dimension
Distinct(
Union(
Distinct( table1[location] ),
Distinct( table2[location] ),
Distinct( table3[location] )
)
)
