Dynamic Level Selection in Hierarchy (Matrix view)

anandraman

To achieve your requirement, first we should create a hierarchy for your hierarchy table.

Then you should know that the built-in slicer visual cannot be used to put hierarchy fields. We need to import a custom visual called HierarchySlicer. You can get it from choosing import a custom visual at Visualizations pane and Import from store.

After importing the HierarchySlicer, put the hierarchy field in Fields, and it should be like this when choosing expand all:

Then you can use it to filter your matrix.

Thanks,
Xi Jin.