I'm having problems with handling hierarchies

[Luizcarlospf]

Hello, I'm having trouble creating hierarchies.

I received the data separately.
I have a column with the "hierarchy" that I divided by the delimiter "|" (PathConcat), the level of each level of the hierarchy and the description.

I tried to use the DAX path function and I'm having trouble relating it correctly

the hierarchy is going wrong and is not making the relationship correctly

how do i solve this problem?

[v-deddai1-msft]

Hi @Luizcarlospf ,

Would you please try to create a hierarchy by level columns and put it to rows. Please refer to https://www.tutorialgateway.org/create-hierarchy-in-power-bi/. If the issue is still existing , would you please show us some sample data (pbix file) by onedrive for business.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[PhilipTreacy]

Hi @Luizcarlospf 

Not quiet sure what problems you are encountering, creating the hierarchy should be fairly straightforward.

Check these for reference

How to create and use a Power BI Hierarchy - YouTube

How to Create a Hierarchy in Power BI (Explained Simply) (spreadsheeto.com)

Regards

Phil