Forum Discussion

netanel's avatar
netanel
Post 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 each row.
How do I bring only the cells that have Value in them?

 

Need Help

8 Replies

  • TomMartens's avatar
    TomMartens
    Super 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
      Post 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
        Community 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