Show two rows on same level

[annade]

Hi,

I want to show row information on the same level. I am using the Matrix but only get the drill down option.

As an example, I want to display item number and item description on the same row, not duplicating the data in the column level.

The below example is from a Excel pivot table but I experience the same thing, i.e. the item description appears on the level below. 

Merging cells is not an option. My question is if I could choose what rows to display next to each other.

Thanks in advance.

Anna

[xiaoqi]

Hello all,

After I switch off the "Stepped Layout", it's able to display in same level.

However, does anyone see below result, looks like, by default, only the first column is displayed with the "plus" sign in the left, I can only click that "plus" then the 2nd expected column shows, but only the row I clicked the "+" sign.

Can we ste all header columns show their value without clicking "+" one by one?

Thanks,

Xiaoqi

[MFelix]

Hi @xiaoqi ,

You have two options

1s option - Rigth click on the first column and select expand all levels

2nd option - on the header of the matrix you should see 4 arrows the last one that is an arrow that expand to two it will drill down all the levels at once, be aware that if you have hierarchy also on the columns you need to select the rows or columns on the list that shows also on the header of the matrix.

[xiaoqi]

Thanks a lot Miguel, that perfectly works, now all are expanded.

Xiaoqi

[dilumd]

Hi,

If you need the drill down option, matrix is the only option. But you have switch off sub totals form the matrix values want be duplicated. However, tabular form in pivot table is still not there in the power BI.

[MFelix · Accepted solution]

Hi @annade,

You should turn off the Stepped layout, in the image below you have how to turn it on/off, should give you expected result.

Regards,

MFelix

[annade]

Thank you this helped me!

[MFelix]

Hi @annade.

Didn't mention on my post but if you choose the drill down until the last level (button with two arrows connected on the left side) it will give you a table look.

But probably you already figured it out.

Regards,

MFelix