Expansion of a hierarchy to all levels in a matrix

[MirianaDF]

Buonasera, ho problemi ad espandere una gerarchia (righe) a tutti i livelli all'interno di una matrice. Ho cercato online e dice che dovrei andare su Formato e cercare l'opzione Espandi a tutti i livelli, ma non ho questa opzione. Come devo procedere?

Grazie in anticipo.

[arvindsingh802 · Accepted solution]

As a workaround try this
go to the Matrix settings, Row Headers > Options, turn off Stepped Layout.
Then save your file with expanded layout and publish

[v-menakakota · Accepted solution]

Hi @MirianaDF ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

Instead of using the 'Format' pane, right-click on the Date table or Date column, and may able to see the 'Expand all' option.I tried creating locally.
Here’s a screenshot for better understanding:

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Regards,
Menaka.

[v-menakakota]

Hi @MirianaDF ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you and Regards,
Menaka.

[v-menakakota]

Hi @MirianaDF ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[rohit1991]

Hi @MirianaDF ,

Se l'opzione "Espandi a tutti i livelli" non è disponibile nella formattazione della matrice in Power BI, ci sono alcune alternative per ottenere lo stesso risultato. Prima di tutto, assicurati di aver selezionato correttamente la visualizzazione Matrice e di avere una gerarchia definita nelle righe (es. Categoria > Sottocategoria > Prodotto).

Se l’opzione di espansione non appare nel pannello Formato sotto Righe, prova ad abilitare l’espansione manualmente cliccando sull’icona della freccia doppia accanto ai livelli della gerarchia direttamente nella matrice. In alternativa, puoi abilitare i pulsanti di espansione andando su Formato → Totali e intestazioni → Icone della matrice e assicurandoti che siano attivi. Se stai lavorando con campi calcolati o misure, verifica che la gerarchia sia costruita correttamente nella tabella di origine. Infine, se la gerarchia proviene da una tabella dimensionale con una relazione uno-a-molti rispetto ai dati della matrice, assicurati che la relazione sia attiva e ben definita nel modello dati. Se nessuna di queste soluzioni risolve il problema, potrebbe essere un bug o una limitazione della versione attuale di Power BI, quindi prova ad aggiornare il software o verificare le impostazioni dell'ambiente di lavoro.

[v-menakakota]

Hi @MirianaDF ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Poojara_D12 · Accepted solution]

Hi @MirianaDF 

If you are unable to find the "Expand to all levels" option in the Format pane of your matrix visual in Power BI, there are a few things to check. First, ensure that your matrix contains a hierarchy in the Rows section, meaning multiple fields that naturally roll up into each other (e.g., Category → Subcategory → Product). If the hierarchy is set up correctly, you should see small expand/collapse icons next to the row headers. If these are missing, check the Visualizations pane → Format (paint roller icon) → Row headers, and enable “+/- icons” to manually expand the levels. Additionally, go to the Data/Drill tab in the Power BI ribbon and check if the Expand all levels option is available there. If you still cannot expand, verify that your Power BI version is up to date, as older versions might not support this feature. Lastly, ensure that the dataset supports hierarchy expansion, as some direct query models or flat tables may not behave like traditional hierarchies.

[v-menakakota · Accepted solution]

Hi @MirianaDF ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

Instead of using the 'Format' pane, right-click on the Date table or Date column, and may able to see the 'Expand all' option.I tried creating locally.
Here’s a screenshot for better understanding:

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

Regards,
Menaka.

[arvindsingh802 · Accepted solution]

As a workaround try this
go to the Matrix settings, Row Headers > Options, turn off Stepped Layout.
Then save your file with expanded layout and publish