Re-order hierarchy table

90 viewsre-order sort table

Sorry i’m really new to PowerBi. I’m using the Hierarchy XViz tool to create a P&L that can drill down to a general ledger code however, i’m wanting to reorder the hierarchy as currrently its in alphabetical order.

I thought it would be as simple as creating a level order column in the underlying data and then sort by that, but i do not seem to have “sort” as an option.

I also want to reorder other levels that i have in the hierarchy (currently i have 4 levels) – can you reorder for all 4 levels?

Asked question