Forum Discussion
Slicer value based on column selection
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
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.
2 Replies
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.
Allison,
Thanks you for your response it call bridge table
Thanks,Oded Dror
