Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can multiple slicers use multiple inactive relationships to share a roleplay table?
At an animal hospital there are 5 vets.
It takes any 3 vets to operate on a pet.
Vet 1 is the surgeon.
Vet2 is the anaesthetist.
Vet3 does the stitches.
There is a Dim Vet table and Fact Operations tables,
with inactive relationships and role play USERELATIONSHIP measures.
How can I change the attached PBIX to slice by vet1, vet2 and vet3?
Must I create 3 vet tables or can the 1 vet table be shared on all 3 slicers?
Thank you
Solved! Go to Solution.
@speedramps , if you need three slicers to have different values, then you need three different tables and may be independent. This what I have done in the case of the date table. In my case they are joined on the same date, so no other option than an independent table. Userelationship with the single table is only useful when you choose same value
my date example: https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
@speedramps , if you need three slicers to have different values, then you need three different tables and may be independent. This what I have done in the case of the date table. In my case they are joined on the same date, so no other option than an independent table. Userelationship with the single table is only useful when you choose same value
my date example: https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |