Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Parent-Child hiearchy handling with multiple Parents

The classic Parent-Child hierarchy is quite trivial these days with very thorough explanations to be found from multiple sources online.    However, when it comes to multiple parent-child hierarchy...
Show and Tell
v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi danielhjorvar,

 

In Power BI we choose to manage the fact table, and build the relationships between different tables. Actually Power BI deals with the actual data, which is used to build reports.

I think the hierarchy you mentioned here could be accompulished by creating hierarchy in Report View, if this hierarchy is needed in reports building.

Right click on the item in the Fields pane, we could see there is New Hierarchy available.

In addition, we could manage table relationship in Relationship View in Power BI desktop, check the article below for more details:

Create and manage relationships in Power BI Desktop

If the hierarchy here is used for data access, then you may take a look at the Role Level Security in Power BI:

Row-level security (RLS) with Power BI

Please reply back if you need any further assistance on this topic.

Regards

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Thanks for the replies Greg_Deckler & v-micsh-msft

 

What I'm dealing with is that I have a unique set of sub-accounts (Level 1). Each one of those account belong to head-account (Level 2) and one head account only. For this dilemma I've used hierarchy with good results.

 

However.

 

The head-accounts can belong to one or more Totals (Level 3) where multi-parent hierarchy scenario steps in.

 

Maybe I'm overthinking this but I simply cannot create this multi-parent hierarchy between the head-accounts and Totals

  • v-micsh-msft's avatar
    v-micsh-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Hi Danielhiorvar,

     

    Would it help to create a table for the Head account (Level 2) and the total (Level 3)?

    For those who have two totals, just create two records for them. For Example, we now have a table with Head Account and the Total.

    One Column for Head Account and one for Total.

    Head Account

    Total

    1

    A

    2

    B

    2

    A

    3

    C

    ....

    Head Account 2 have two Totals,  then create two record for it. After that, create relationship for Head Account and the Total for other reousrce tables.

     

    Regards