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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.