Conditional Column Exclusion In Metrix

[Anonymous]

Dear Experts,
We have the below matrix , however the customer wants to keep the Target column only for the prior week ( please refer to the picture below).

I have tried the option of dragging few columns , but getting the below marked boundaries against the hidden columns,

How can we achieve this?
Thanks in Advance.

Thanks & Regards,

Abhisek

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

As I do not have your specific data, I have created a similar template for your reference at：

Base data:

visual:（Remove the circled parts of the image.）

Create the below measure:

TEST = IF(MAX('Table'[type2])="T2c",IF(MAX('Table'[type1])="T1",0,BLANK()),MAX('Table'[value]))

Use the measure to create visual:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien