Ordenamiento en matriz por jerarquia

[Anonymous]

Hola,  Hay alguna manera de quitar la jerarquia de una matriz por que tengo en Filas 2 datos Distrito y Warehouse pero necesito que el primer dato (Distrito) este en la parte izquierda  y despues Warehouse  donde no se agrupe por distrito por que no toma el ordenamiento que quiero al agrupar primero Distrito  

[v-prasare]

@Anonymous, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super users for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare · Accepted solution]

Hi @Anonymous ,

Hope your doing well.

In most pivot table tools (Excel, Power BI, etc.), when a hierarchical structure is created (here, District → Warehouse), the data is grouped by the first level (District) and then sorted within each group by the second level (Warehouse). However, sorting the entire table alphabetically by Warehouse while preserving the hierarchy is not supported directly because the hierarchy inherently enforces the grouping.

Can you thry this alternative but will make data more complex:

• Remove the "District" hierarchy from the rows and include it as a column.
• Now, you can sort the "Warehouse" column alphabetically across all rows.
• The District information will remain visible but no longer group the data.

Thanks,

Prashanth Are

MS Fabric community support.

Did we answer your question? Mark post as a solution, this will help others!

If our response(s) assisted you in any way, don't forget to drop me a "Kudos"

[Anonymous]

Quiero que me ordene alfabeticamente todos los datos de Warehouse pero me agrupa  primero District, la condicion es mantener el orden  de izquierda a derecha en las filas District 1 Warehouse 2

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...