How to expand all remaining rows horizontally from second (certain) row

[JustinDoh1]

I am sharing my PBIX file here.

I am trying to display all rows as shown below when I click the second row (Expand).

That means: when I click "Expand" (like D or E), all other rows / remaining fields would display horizontally at the same time like case below where I do not have to click each row to display/open all rows of data outcome horizontally.

This is how visual is structured using Matrix:

What I did/learned from my co-worker was, I set the Stepped layout as "Off" on the Row headers --> Options  --> Stepped layout (to make somehow works).

But, nothing else was done.

It works if I tried to expand all rows and save the PBIX file as last mode/status.

But, other than the behavior due to saving in that mode, it does not expand (if I try from the first time) automatically.

I am using Matrix for this visual.

Do I have to use other visual (other than Matrix) to make this work (expand all the way for all rows)?

I am trying to replicate something that works in Excel to PowerBI, but I am not sure it is possible.

Thanks.

[AllisonKennedy]

@JustinDoh1 

The only solution I have come up with for this issue is to create a Measure for the values you want expanded. Note this only works if you're already at the lowest level of granularity and 'expanding' will just give 1 row for each.

Create measures for selected values:

Deficiency Category Selected = SELECTEDVALUE(Table[Deficiency Category])

Then add those selected measures to the matrix in 'Values' and they won't need expanded. 

[JustinDoh1 · Accepted solution]

@AllisonKennedy 

I think I got the solution without using measures.

I had to do this to make it work.

[AllisonKennedy]

@JustinDoh1  That's a good alternative - I didn't think of that. May just need to add a note to the report as End Users will change frequently and they won't know that trick either. 🙂 

[JustinDoh1]

@AllisonKennedy 

Thank you for your feedback.

I am still having a hard time making this work.. Somehow, when I put the measure into the Values area, values get duplicated.

[AllisonKennedy]

@JustinDoh1 

Ah, yes, as soon as you have multiple measures in Values AND something in columns too you get too much info going on, so either need to create explicit measures for everything (not ideal) or use your wonderful solution!