Hide column with blank values in matrix

Hi,

I have a matrix as shown in the picture below.

Rows: [state]

Columns: [product]

Values: [measure1] and [measure2]

Since all values for [measure2] under 'Product1' are blank, I want to hide it. 

Tried below but it did not help

1. Under Vizualizations > Columns > [product] dropdown > 'Show items with no data' is unchecked.

2. Under Filters > [measure2] > Advanced filtering > applied "show items when the value 'is not blank'" option

3. Applied above filter on [product] field too

Appreciate any suggestions on this.

Thank you!