Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |