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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Creating a Matrix with a static column

Hello,

 

I have data that I am displaying in a Matrix.

chowell2_0-1678127722947.png

The first column is a name, and then the rest of the columns are the month in which the data is collected. I would like to insert a column that is just a more detailed description of the first column. The end result would be a matrix with two static columns and then fluctuating date columns, but I can't find out how to insert the 'description' row into the matrix.

 

Any help would be greatly appreciated.

1 ACCEPTED SOLUTION
andhiii079845
Solution Sage
Solution Sage

The addional information belongs to the name? Than create a new column in the table where the name column is. Insert in this column your description and than add this column to "row" to the matrix. 

andhiii079845_1-1678128206017.png

 

Turn off under Format -> row header the +/- icon

andhiii079845_0-1678128190197.png

And make a drilldown and also turn off "stepped layout":

andhiii079845_3-1678128363895.png

 

 

 





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

Proud to be a Super User!




View solution in original post

6 REPLIES 6
alicek
Helper III
Helper III

Hello team! The user interface has updated a lot since this solution was posted, and I can no longer find where I can turn off "stepped layout". Does anyone have updates on how to achieve this in the new layout (in April 2025)? @andhiii079845

andhiii079845
Solution Sage
Solution Sage

The addional information belongs to the name? Than create a new column in the table where the name column is. Insert in this column your description and than add this column to "row" to the matrix. 

andhiii079845_1-1678128206017.png

 

Turn off under Format -> row header the +/- icon

andhiii079845_0-1678128190197.png

And make a drilldown and also turn off "stepped layout":

andhiii079845_3-1678128363895.png

 

 

 





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

Proud to be a Super User!




Do you know how to add a total in bold to this?

Anonymous
Not applicable

I'll try that now, thank you for the quick response

Let me know if you missing something, please mark my post as a solution if it was helpfull.





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

Proud to be a Super User!




Anonymous
Not applicable

It worked great. Thanks for the help!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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