Forum Discussion

yodha's avatar
yodha
Helper IV
6 years ago
Solved

How to Hide empty Columns in Matrix visual?

Hi, is there a way to hide empty columns in matrix visual ? i wanted to hide highlighted columns,   Attached pbix for reference https://www.dropbox.com/s/qllt34kyfcy38gg/Power%20BI%20Example...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi yodha ,

    You can define the size of the column so you can hide then until is invisible just drag the border of the column, be aware that you may need to turn off word wrap on the options on column headers.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

tex628's avatar
tex628
Community Champion
6 years ago

Try this:

Measure = 
IF( (Calculate([Total Cost] ALLEXCEPT(Table ; Table[date])) + Calculate([Total Forecast]; ALLEXCEPT(Table ; Table[date])) = BLANK() ; BLANK() ; [Cumulative Total])


And replace the Cumulative total measure with this. 

/ J

yodha's avatar
yodha
Helper IV
6 years ago

tex628 : i have tried this, but this is removing entire month, but i want to remove only empty columns in the month. Thank you.

 

 

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    That is sadly not possible. When you're using several measures as values in a matrix the columns will always be present as long as there is atleast 1 value that isn't blank(). It's either hide the entire month because the two first measures are empty or show all 3 columns. 

    / J

  • VLey_Gomes's avatar
    VLey_Gomes
    New Member
    1 year ago

    Hello yodha , Were you able to solve your issue with hiding the columns? I'm having the same problem.