Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
LD1
Helper III
Helper III

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.

 

LD1_0-1671448263229.png

 

 

Thank you in advance, 

 

LD

 

 

 

2 REPLIES 2
Anonymous
Not applicable

Hi @LD1 ,

 

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.

LD1
Helper III
Helper III

Maybe with a SWITCH formula ? 

if "Salon" then "1.1 Salon" 

etc. 

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors