Forum Discussion
Helper IDifferent behaviour with Table and Slicer Visuals
Just out of curiosity, is there a reason you don't have a relationship between the Date Table and the D_seller table and have a separate Dimension table for D_Seller? (to avoid a potential relationship conflict). Something like this:
Most Valuable ProfessionalHallo D4imi0n ,
I checked your file, the problem is the relationship.
In the right table you can change it to a slicer because they have a direct connection. So you can get all the years from the Date table and then filter Sales and get the related countries:
The left table you can get all the years from the Date table, but then the relationship to the Geography table cannot be made. The connection would go to the Sales table and then from the Sales table to the Geography table, what is not possible because the filter direction is not allowing that:
In general this is not a common way to create a hierarchy slicer. I would recommend to just add 2 slicers, one for the year and one for the Geography.