topic Re: Ordenamiento en matriz por jerarquia in Data Warehouse

Ordenamiento en matriz por jerarquia

Anonymous — Thu, 30 Jan 2025 00:19:48 GMT

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

Re: Ordenamiento en matriz por jerarquia

lbendlin — Thu, 30 Jan 2025 19:54:51 GMT

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Ordenamiento en matriz por jerarquia

Anonymous — Fri, 31 Jan 2025 00:51:32 GMT

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

Re: Ordenamiento en matriz por jerarquia

v-prasare — Thu, 06 Feb 2025 05:30:33 GMT

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"

Re: Ordenamiento en matriz por jerarquia

v-prasare — Mon, 10 Feb 2025 12:29:40 GMT

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