Slicer value based on column selection

[Oded-Dror]

Hi there,

how to change slicer value based on selected column?
I have Geography Dim connected to a fact Sales 1:M and I created a slicer for that
Everythings works fine but the requirements changes, now I have 3 templates to choose from each template represent different
values in Dim table 
One option was to create a bookmark for each template filtering it to 1 (show)
But I'm wondering if there is a nother way without the bookmark?
Iv'e try to union all templates into one table but its create M:M relationship which I don't need.
Thanks,

Oded Dror

 

[AllisonKennedy · Accepted solution]

@Oded-Dror  Unfortunately this will be a many to many relationship. You can keep your DimGeography table as is, and create a table that contains CountryID and Template and use a snowflake schema instead, so use the CountryID | Template new table related with BOTH cross filter direction to filter the DimGeography table that has a 1:many relationship SINGLE to sales and filters sales.

[Oded-Dror]

Allison,
Thanks you for your response it call bridge table 
Thanks,

Oded Dror