Forum Discussion
phamilton
3 years agoFrequent Visitor
Need to help filtering table between active and inactive relationship
Hi all,
I have a lookup table for departments and a fact table which contains 2 fields related to the department field. Reporter department and responsible department. The primary relationship is the reporter department. I have a slicer using the lookup value, which works great for my visuals but not for the table data as it only shows records by the reporter department. How can a create a slicer that allows the users to switch between Reporter Department and Responsible Department?
Thanks
Pete
1 Reply
- lbendlin
Super User
you can only change relationships (temporarily) through measures. If you need to use slicers then you will have to duplicate your lookup table.