Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
Hello,
I have data that I am displaying in a Matrix.
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.
Solved! Go to Solution.
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.
Turn off under Format -> row header the +/- icon
And make a drilldown and also turn off "stepped layout":
Proud to be a Super User!
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
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.
Turn off under Format -> row header the +/- icon
And make a drilldown and also turn off "stepped layout":
Proud to be a Super User!
Do you know how to add a total in bold to this?
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.
Proud to be a Super User!
It worked great. Thanks for the help!
User | Count |
---|---|
60 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
40 | |
39 |