Hierarchy ~Chart Visual (Akvelon) - same id, multiple parents?

[ianf123]

Hi -

Does anybody know if there is a way , using the Akvelon Hierarchy Chare visual to represent relationships where an element can belong to more than one parent?

I can get the visual to show this simple relationship hieraerchy...

Id	Parent	Level
Service Group A		Top
Service A	Service Group A	Service level 1
Service B	Service Group A	Service level 1
Service C	Service Group A	Service level 1
Service D	Service C	Service level 2

but when I introduce a new row, I get an error message "items have the same id"

Id	Parent	Level
Service Group A		Top
Service A	Service Group A	Service level 1
Service B	Service Group A	Service level 1
Service C	Service Group A	Service level 1
Service D	Service C	Service level 2
Service D	Service B	Service level 2

Is there an alternative visual I can use to achieve this, or can I do something to get this working the Akvelon Hiercharchy Chart?

[v-juanli-msft]

Hi @ianf123 

The error occurs for you have mutiple parent for the same child.

It is by design both for the  Hierarchy Chart Visual (Akvelon) or "PATH" dax function.

You could deal with the duplicate error following the thread below

https://community.powerbi.com/t5/Desktop/Dealing-with-PATH-Duplicates-Errors/td-p/279549

Best Regards
Maggie

[v-juanli-msft]

Hi @ianf123 

It seems the two tables are not your original data?

Could you share some example data for me to analyze?

There is a video how to create Akvelon Hiercharchy Chart.

https://www.youtube.com/watch?v=VVV7WwSPDsA

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ianf123]

Hi,

I have created and 2 example pbix's to demonstrate.

In my data its possible to have the same service under different parents as well as under other services.

Can this be represented in Arkvelon Hierarchy Chart?

Photos attached -

Thanks for your help!