Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create a hierarchy (sort and organize) with different drill-down

Hi everyone, 

 

I have a request please. Could you tell me if is it possible to create a hierarchy with a couple of drill-down in Power BI?  

 

I would like to know how i can sort and organize those different field by categorie without figure's sort or alphebatical sort.

 

 

 

Thank you in advance, 

 

LD

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Maybe with a SWITCH formula ? 

    if "Salon" then "1.1 Salon" 

    etc. 

    Maybe you have a better idea for the order of field. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Normally in the fields pane, if you drag a field into another field, the hierarchy will be created.

    About more details, you can refer to

    What a Power BI Hierarchy Is, and How to Use it? - RADACAD

     

    Best Regards,

    Stephen Tao

     

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