Hide column using Conditional Logic

[JustinDoh1]

I am trying to hide column (in Matrix visual) based on the date.

So, from July 2022, I am trying to hide one column.

I am sharing my PBIX file here.

Currently, from July 2022, there will be no data for Rating1, so I am trying to hide this column if user selects July 2022 and going forward.

Until June 2022, there was data for Rating1, so if user selects June 2022 or previous month (which I only display June 2022 here), it should show visual for Rating1 still as well.

July 2022:

June 2022:

So, I am trying to create a logic to hide Rating1 if date >= 'July 2022' , something like that.

How do I go about doing this?

[Arul · Accepted solution]

@JustinDoh1 ,

I have tried to hide the values in the column but getting rid off them from the table I am not sure. Check if it helps or not.

Thanks,

Arul

[Arul · Accepted solution]

@JustinDoh1 ,

I have tried to hide the values in the column but getting rid off them from the table I am not sure. Check if it helps or not.

Thanks,

Arul

[JustinDoh1]

@Arul 

I have a question.

Is there way to automatically size down the width of the column if there is no value (vice versa: automatically size up the column if there is a data)?

Thanks.

[Arul · Accepted solution]

@JustinDoh1 ,

I don't think so.

Thanks,

Arul