Forum Discussion

RichFlorida's avatar
RichFlorida
Helper V
2 years ago
Solved

Hiding Row Column in a Matrix Visual

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.

 

 

Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    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!

6 Replies

  • dk_dk's avatar
    dk_dk
    Super User
    2 years ago

    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's avatar
      SamWiseOwl
      Super User
      2 years ago

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

       

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    2 years ago

    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!