1

I'm trying to find a way to sort a hierarchy in Power Bi or Excel.

I would like to find a way to keep the (visual) structure in order. Keep the nesting between each parent and each child.

Here is the order I want to keep in Power Bi or Excel :

The order i want to keep in Excel or Power BI

Here is what i got actually in Excel (not filtered, only the original file order. And as you can see, this in no way reflects the actual structure of the product. The levels are jumbled up and not consistent with each other... ) :

Wrong order image

I tried to add a new 'sorted_order' column and add something alphabetic but no success. Something like A AA AB AC ACA ACB ACD AD ADA But it's obviously not the best way to do this.

So if you guys have an idea ... I work on Python.

Thanks for you help

Improve this question
Related questions
2191
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
581
What is the most efficient way to parse a flat table into a tree?
1003
Peak detection in a 2D array
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.