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.
Hi All,
We are using a star schema:
- Fact Cost
- Fact Price
- Dimension Agent
- Dimension Team
- Dimension Workgroup
There is a hierarchy:
- Agent <> Team
- Agent <> Workgroup
This hierarchy is not in one table but through the fact tables so it is not possible to create a hierarchy with the right-click > new hierarchy.
We also have 3 different slicers on Agent, Team and Workgroup.
My Question:
If I select an Agent in the Slicer, I would like to only see the Teams and Workgroups in the other slicers that are linked to the selected Agent ( through the 2 fact tables).
I think this is possible, because there is a custom visualization called 'HierarchySlicer' which does this but I would like to use this functionality in the default Slicer visualization.
I've created a sample Power BI report:
https://drive.google.com/file/d/1t_6BzTqiJH219q-tx0F8tgrH9WKq0Jw2/view?usp=sharing
I hope someone can help me!
Thank you in advance!
Marco
@Anonymous ,
You may set cross filter direction to 'Both' in the Edit relationship dialog.
Not possible if you have multiple fact and dimension tables.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |