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.
Hi,
I currently have the following problem. I want to have 2 columns set as rows in my matrix. I want to have item no. and the description of the item number. I have added the 2 columns into rows but it displays with a + button shown on the picture below. I want item and the description next to each other as different collums.
I must use matrix, can't use table!
Can someone help me?
Solved! Go to Solution.
@Anonymous That toggle is right above the Stepped layout toggle. You can turn it off.
@Anonymous You have to toggle off Row subtotals I believe. It's 2 cards down from the Row headers card.
Would recommend making a custom column that concats the Item and Description into a single value then you can use that as your row descriptor.
Unfortunately the matrix visual is somewhat limited in it's design.
Hi Alexander,
Thanks for your reply. This isn't possible beceause this will cause trouble when i am exporting this into excel. Need the the two columns seperate.
@Anonymous Turn off Stepped layout:
@Anonymous You have to toggle off Row subtotals I believe. It's 2 cards down from the Row headers card.
Hi @Greg_Deckler ,
This helped a lot. Is it possible to remove the + button? Or is that something that can't be removed?
Thanks
@Anonymous That toggle is right above the Stepped layout toggle. You can turn it off.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
56 | |
38 | |
35 |
User | Count |
---|---|
85 | |
66 | |
59 | |
46 | |
45 |