Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
annade
New Member

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

 

Pivot table.png

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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.

1111.png

 

Regards,

MFelix

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

7 REPLIES 7
xiaoqi
Regular Visitor

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.

xiaoqi_0-1627316919986.png

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.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

Xiaoqi

dilumd
Solution Supplier
Solution Supplier

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
Super User
Super User

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.

1111.png

 

Regards,

MFelix

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you this helped me!

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.