Conditional Format all columns up to a certain column based on values

Hi,bhanu_gautam .
Hello,Anonymous .I am glad to help you.
Like this?

I noticed that in the original data you provided you had already processed the data for the conditions you described: they were correctly labeled as 0, so I marked the cells that were not empty and had a value equal to 0.
Is your original data also the same as the test data you provided: the data is marked as 0 beforehand, if so, you only need to mark the cells that have a value of 0.

I created three dimension tables based on the fields

Phase_ = VALUES('Table'[Phase])


Subphase = VALUES('Table'[Subphase])


Team_ = VALUES('Table'[Team])

After placing them in the matrix, it relies on relational filtering to show null values (data that doesn't exist by itself)

Relying on the filtering of the matrix itself, filtering out cells with value = 0, as you mentioned in your description, indicates a step that should not be skipped (which is actually skipped)

If your actual data and your test data is not consistent with the definition of the criteria, please tell later and promptly correct my misunderstanding.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.