Forum Discussion

yodha's avatar
yodha
Icon for Helper IV rankHelper 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.pbix?dl=0

 

Thanks in Advance.

 

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.

     

13 Replies

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Do you have this setting applied? 

    • yodha's avatar
      yodha
      Icon for Helper IV rankHelper IV
      6 years ago

      tex628 :Thanks for the reply. Yes,this setting is already applied.

      • Tahreem24's avatar
        Tahreem24
        Icon for Super User rankSuper User
        6 years ago

        yodha ,

         

        You can show 0  instead of empty row.

        Total  = Sum(Table[Sales])+0

        OR

        Total = Your Measure+0

         

    • yodha's avatar
      yodha
      Icon for Helper IV rankHelper IV
      6 years ago

      amitchandak : Thanks for the reply, i just tried this solution but it's not working.

       

       

       

       

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    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.

     

    • yodha's avatar
      yodha
      Icon for Helper IV rankHelper IV
      6 years ago

      v-yingjl : Thanks for the reply. This is not best way to do, atleast in my case. Many columns are there in my original PBIX and i do refresh daily this report. So when i refresh columns will come back to normal position. 

      • v-yingjl's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi yodha ,

        If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!


        Best Regards,
        Yingjie Li