Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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.
User | Count |
---|---|
84 | |
82 | |
66 | |
52 | |
46 |
User | Count |
---|---|
100 | |
49 | |
42 | |
39 | |
38 |