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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote 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
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.