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 en...
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!

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?

 

dk_dk's avatar
dk_dk
Super User
2 years ago

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