Problem with matrix, column shows all the values possible.

[Anonymous]

Good morning,

I am finishing creating my P&L in PowerBI with matrix.
When attaching the status of each one of them by columns, all the possible values appear, not the one associated with that single row.

I want to show only the column that has values, not the others... So for example, for the first one the status is 'Approved' not the others...

I have tried a thousand things, but I can only add the calculated columns themselves by columns, can you think of something?

Thanks a lot 🙂

[v-zhangti]

Hi, @Anonymous 

Can you provide more sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.