Dynamic Level Selection in Hierarchy (Matrix view)

[anandraman]

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 which has 3 levels and one Leaf Node(ID). Other is Fact table which has sales data at Leaf Level i.e. ID level.

My requirement is to show all the distinct values of all the levels in one single slicer. that means my slicer will have A1,B1,A11,B11,A21,B21......1.2.3.4.5.6.7.8. in dropdown list.

So when we select any value in the slicer my Matrix view hierarchy should start from that selected value.

For Example If i have selected B21  in slicer then my report should look like below:

If i have selected A34 in slicer then my report should look like below:

Any suggestion?  

Thank you in advance.

[v-xjiin-msft · Accepted solution]

@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.

[anandraman]

Any suggestion guys?