Forum Discussion
Hiding Row Column in a Matrix Visual
Hi RichFlorida
- You could turn the text wrap off
- Change the font colour to match the background of the visual.
- Put something over the top like a rectangle to hide it
- Create a calculated column with nothing but spaces (different number for each row) and use thatHidden column = REPT(" ",'Product'[ProductId])
All some what hacky but thats life!
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:
- In the visual settings, under Row headers, set the text color to white, and turn off banded row color
- 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
- 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
I like this, elegant.
Can I ask why for step 3 you can't just give the column and empty aliase?
@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
Haha, you absolutely could. Typical example of me over-engineering a solution when there is a simpler way. well spotted! 😄
