Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Slicer issue

Hi All, I am facing issue while trying to use one of the column as slicer. Below is the data model structure   I wanted to use Name as slicer can some one please suggest how can we achieve ...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Change the filter direction back to single on both relationships then create a new dimension table for names, e.g.

    Names =
DISTINCT (
    UNION ( DISTINCT ( 'Table 1'[Name] ), DISTINCT ( 'Table 3'[Name] ) )
)

    Link this new table to both table 1 and table 3 and use the column from the new table in your slicers and visuals.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Change the filter direction back to single on both relationships then create a new dimension table for names, e.g.

Names =
DISTINCT (
    UNION ( DISTINCT ( 'Table 1'[Name] ), DISTINCT ( 'Table 3'[Name] ) )
)

Link this new table to both table 1 and table 3 and use the column from the new table in your slicers and visuals.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

got it thanks johnt75  I tired similar bridge table approach but was facing some issues.

 

I will try the way you mentioned and will update the forum

 

Thanks again for your help