Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
phamilton
Frequent 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 1
lbendlin
Super User
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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.