The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
you can only change relationships (temporarily) through measures. If you need to use slicers then you will have to duplicate your lookup table.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |