Forum Discussion

anandraman's avatar
anandraman
Helper I
8 years ago
Solved

Dynamic Level Selection in Hierarchy (Matrix view)

Hi,   I have a requirement to select the level in hierarchy in Matric view Dynamically based on user selection. here is detail about my requirement:   I have 2 tables. 1 Hierarchy Table w...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    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.

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

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.