The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
@Rgieltjes_Meyn That toggle is right above the Stepped layout toggle. You can turn it off.
@Rgieltjes_Meyn 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.
@Rgieltjes_Meyn Turn off Stepped layout:
@Rgieltjes_Meyn 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
@Rgieltjes_Meyn That toggle is right above the Stepped layout toggle. You can turn it off.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
76 | |
65 | |
52 | |
51 |
User | Count |
---|---|
127 | |
116 | |
78 | |
64 | |
63 |