Forum Discussion

phamilton's avatar
phamilton
Frequent Visitor
3 years ago

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

  • you can only change relationships (temporarily) through measures. If you need to use slicers then you will have to duplicate your lookup table.