Help whit Amount

[netanel]

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?

[TomMartens]

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]

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]

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]

How do I do what you mentioned?

[v-xulin-mstf]

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

[netanel]

https://1drv.ms/u/s!AonyYI-TdspHgUj9wL75gI-dG1ZY?e=TkdrDy

[v-xulin-mstf]

Hi @netanel,

Sorry, I forgot to add that pbix file will be helpful.

Best Regards,

Link

[netanel]

Thank you!

https://1drv.ms/u/s!AonyYI-TdspHgUj9wL75gI-dG1ZY?e=b5jSdx