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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AprilD
Regular Visitor

Where is the Old Matrix Table visual?

Hello,

 

Previously the old Matrix table visual works best for my report. Then on June 2017 the updates included the New Matrix Table preview which helps to bring a new approach on the table. It shows a drill down option for the table. Therefore your have variation of Matrix Tables. That was great as we have more options to show the data. However, on July 2017 updates, the Old Matrix Table was no longer available, and remains the June Matrix Table preview. I oftenly use the Old Matrix Table as it shows at the very first glance the Sub Categories without the need of drill down option.

 

My question is, where is the old Matrix Table visual? Or is there a way where I can show a Table with Sub Category without clicking the a drill down?

 

Your response would be highly appreciated.

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @AprilD,

 

 

The old Matrix visual was replaced by the new one however you can have the same look in your matrix if you follow this steps:

 

- Format

- Row Headers

- Stepped layout off

- On the table select the At the lowest level of data:

T.png

 

Also reference to this link to more informations.

 

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

10 REPLIES 10
skkelly
Frequent Visitor

Hi,

I'm having the same problem where I need to see the subcategories but my format menu doesn't have a Row Headers option:

I can only see:

 Edit Interactions | Bring forward | Send backward | Align | Distribute.

 

Does anyone have any ideas?

 

SK

Hi @skkelly,

 

The format option that is refered is on the visual not on the toolbar.

 

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



Hi MFelix,

 

Thanks for your reply! I saw on one of the previous replies that the drill down button was highlighted. Should I be able to right click on the visual to get formatting options (I can't right click on it).

 

sk

@skkelly,

 

The format options that I refer are on the right side of the PBI

 

1111.png

 

In this link you have a complete explanation.

 

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



Ah, THAT format button (I'm still fairly new to Power BI). IT WORKED! Thank you MFelix, you've made my day! 🙂

MFelix
Super User
Super User

Hi @AprilD,

 

 

The old Matrix visual was replaced by the new one however you can have the same look in your matrix if you follow this steps:

 

- Format

- Row Headers

- Stepped layout off

- On the table select the At the lowest level of data:

T.png

 

Also reference to this link to more informations.

 

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



Hello @MFelix,

 

What is the solution for Power BI online ?

 

I cannot see that option under Row Headers in the Online Version.

 

Thanks

Hi @Wilsonf,

 

It's on the same option Row HEader, however first of all you need to select the matrix visual again, if you choose your matrix you will see no visual is selected on the right side of the screen, selected and then go to options.

 

MATRIX.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



Hi MFelix; 

 

thanks for the workaround. 

However, if I add a new level of hierarchy allowing user to drill down; coming back to first configuration is painful...any idea?

Thank you @MFelix this do the tricks. Awesome!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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