Hiding Row Column in a Matrix Visual

[RichFlorida]

Hello All,

Is there a way to hide the 'Rows Column" (country) in the Matrix Visual below, while keeping all the values displayed?

I've tried resizing the column and make it narrow enough to disapear, however it caused the text to wrap and for each row to be very wide, so this was not a feasable solution (see below).

Any ideas greatly apreciated.

[dk_dk]

Hi @RichFlorida 

I have a solution but it is a bit cumbersome.

Assuming you have a solid colored (white for this example) background for your report:

On the left is the original matrix, on the right the result.

To achieve this:

1. In the visual settings, under Row headers, set the text color to white, and turn off banded row color
2. Under Grid > Border, set the color to white, OR select the Values section and then top, if you still want to keep a separator line under the headers
3. now the cumbersome part, ro get rid of the "name" header in my screenshot: go to Column headers and set the text color to white. oh no all the headers are gone -> now you have to Specific column, and for each series turn on Apply to header, and then under Values set the text color back to black.

Additionally, you can also reduce the  row header font size so that it takes less whitespace on the report page. You wont be able to place this visual flush to the left edge of the report page, but otherwise it should work,

Hope this helps!

Best regards,
Daniel

[SamWiseOwl]

I like this, elegant.
Can I ask why for step 3 you can't just give the column and empty aliase?

[dk_dk]

Haha, you absolutely could. Typical example of me over-engineering a solution when there is a simpler way. well spotted! 😄

[RichFlorida]

Thank you @SamWiseOwl and @dk_dk for your replies...

 I will try your solutions and let you know...!

[RichFlorida]

@SamWiseOwl : Turning off the Text Wrap allowed me to resize the column by dragging, I was able to hid it.

 @dk_dk Your detailed instructions worked in making the content of the column disapear, I still needed to turn off  the ROw header Text Wrap to make the white space disapear.

Thank you both

[SamWiseOwl · Accepted solution]

Hi @RichFlorida 

1. You could turn the text wrap off 
2. Change the font colour to match the background of the visual.
3. Put something over the top like a rectangle to hide it
4. Create a calculated column with nothing but spaces (different number for each row) and use that
   Hidden column = REPT(" ",'Product'[ProductId])
   

All some what hacky but thats life!