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

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

5 REPLIES 5
andhiii079845
Super User
Super User

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

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.