Hide column with blank values in matrix

[BindiyaThota]

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!

[lbendlin · Accepted solution]

Not possible by default.  Use cusom matrix design or if this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[BindiyaThota]

Thanks for confirming that is not possible by default.