cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anandraman
Helper I
Helper I

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:

 

Capture.JPG


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:

 

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

 

Capture3.JPG

 

Any suggestion?  

 

Thank you in advance.

1 ACCEPTED SOLUTION
v-xjiin-msft
Solution Sage
Solution Sage

@anandraman

 

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

1.PNG

 

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:

 

2.PNG

Then you can use it to filter your matrix.

 

3.PNG4.PNG

 

Thanks,
Xi Jin.

View solution in original post

2 REPLIES 2
v-xjiin-msft
Solution Sage
Solution Sage

@anandraman

 

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

1.PNG

 

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:

 

2.PNG

Then you can use it to filter your matrix.

 

3.PNG4.PNG

 

Thanks,
Xi Jin.

View solution in original post

anandraman
Helper I
Helper I

Any suggestion guys?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors