Forum Discussion
Powerbi hierarchy Build
Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi Greg_Deckler
I posted this in my previous chat as I am anot able to build hierarchy like this the screenshot which is listed below.
So I have one cert_Details in that I have 1 column Owner in that I have hierarchy build like 4 to 5 people in 1 column so I have Separated like Owner 1, Owner 2 , Owner 3 etc so How to build hierarchy like the screenshot listed above in slicer or tree visual in Powerbi.
This kind of problem is not listed above. Can you help me to resolve this..
Hi Team
I have more issue I have tree based hierarchy in Hierarchy slicer option so for that I have to sync up with Matrix table so suppose if I select anything in Hiearchy Slicer suppose any manager name for example :- Justin - so I am seeing the Tree based hierarchy for justin in Hierarchy slicer and same should come in matrix tree based automatically so how to sync this.
can you please let me know here I am attaching the screenshot for the reference, Do let me know
Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
Based on your description and image, it looks like you're using a Hierarchy Slicer to display a tree-based structure (e.g., a reporting hierarchy), and you want to sync the selection from that slicer with a matrix visual, so that when you select someone like "Justin" in the slicer, the matrix automatically expands to reflect their hierarchy.
Please follow below steps to Sync Hierarchy Slicer with Matrix:
1.Make sure both the Hierarchy Slicer and Matrix use the same hierarchy field from the same table.
2.Enable Visual Interactions
Go to Format → Edit interactions, select the slicer, and ensure the matrix visual is set to Filter.3.If using a parent-child structure, use DAX functions like PATH() and PATHCONTAINS() to flatten the hierarchy.
4.Use the slicer selection (e.g., Manager Email or ID) to filter the matrix to show only the relevant hierarchy.
Please continue using Microsoft Community Forum.
If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.