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?

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

        Hi netanel,

         

        It affected by your data structure, could you provide sample data without sensitive information?

        You can refer the ralted post.

         

        Best Regards,

        Link