Hierarchy in Slicers with multiple dimension and fact tables

[Anonymous]

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

[v-chuncz-msft]

@Anonymous ,

You may set cross filter direction to 'Both' in the Edit relationship dialog.

[Anonymous]

Not possible if you have multiple fact and dimension tables.