Forum Discussion
Show two rows on same level
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
7 Replies
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.
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
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.
Thanks a lot Miguel, that perfectly works, now all are expanded.
Xiaoqi
