Matrix - expand all for single row at once

[eddie_bw]

Hi all,

On my report I have a matrix which looks more or less like this:

+ Country | + Risk ID | + Description | Mitigating Measures

Each of those columns can be expanded to see another level.

I would need to bypass the default expand behaviour and show all the columns after clicking the + for Country for a single row.

So the desired matrix would look like that:

+ Country | Risk ID | Description | Mitigating Measures

Can it be done somehow? I don't want to merge columns to display 3 in 1 column.

I hope I have described the scenario clearly 🙂

Thanks in advance for your help.

[v-xuding-msft]

Hi @eddie_bw ,

Hi,

Do you mean like this?

Unofrtunately, There is not a solution for your requirement currently, please manually click on each group.

Or you could combine these fields into one group.

[amitchandak]

@eddie_bw , I doubt it is possible to change the default behavior. May with bookmark and button, you can create that experience

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Possible layout in matrix : https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual