Forum Discussion
thampton
Helper III
Helper IIIFiltering by multiple columns at once dynamically
I have a dim table and two fact tables. My dim table has three columns, ill use the below as an example. Zone | Market | State Eastern ...
That should be the default behavior. You would make a relationship on the State column (the most specific one), then you can add the three slicers from the Dim table. Does that work?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeThat should be the default behavior. You would make a relationship on the State column (the most specific one), then you can add the three slicers from the Dim table. Does that work?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat