Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
5 years ago

Help whit Amount

Hello everyone! I have several columns that contain Value (General, Accoounting, Precentage, Text) And when I display them the Matrix table opens empty cells for me even though there is no Value in...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
5 years ago

Hey netanel ,

 

unfortunately, this is how it works, in contras to an empty row, an empty column will not be removed automatically. I'm pretty sure you will find an idea on ideas.powerbi.com that you can upvote, otherwise create an idea.

 

Regards,

Tom

  • netanel's avatar
    netanel
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Thanks Tom

    But I'm pretty sure there's a formula that says that if there's no value in the columns then that Value will not come

    I'm attaching a picture of my data right now, I'm trying to hide the empty columns that have no Value

     

     

     

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi netanel,

       

      You can display the value on the rows, then you can hide rows which have no value.

      It is not support to do on the columns, maybe you can summit a idea.

       

      Best Regards,

      Link

      • netanel's avatar
        netanel
        Icon for Post Prodigy rankPost Prodigy
        5 years ago

        How do I do what you mentioned?