Hide Columns with zero value in Matrix

[Anonymous]

Hello,

In Power BI - have a matrix with Rows- Category and Columns with Fiscal week numbers and Values with Sales units. I have to hide/surpass the fiscal week number columns with the values zero in sales units.

Please see the below snip for reference

Is it possible to hide these columns?, for example - week 05, week 06.....

Thanks in advance

[cocquer]

very clever

[jdbuchanan71]

You can write your mesure so 0 is returned as BLANK which will leave it out of the matrix if all values in the column are blank.  We do this using a trick of multiplying a number by BLANK returns BLANK and DIVIDE by 0 returns BLANK.  
The first table has just a SUM measure.

Total Amount = SUM ( 'Table'[Amount] )

The second table has the measure to return BLANK for 0

Total Amount no 0 = 
VAR _Amount = SUM ( 'Table'[Amount] )
RETURN _Amount * DIVIDE (_Amount, _Amount)

You can see WEEK2 and WEEK3 are not showing in the second matrix.

[Anonymous]

I tried this and my column is giving blank values but it hasn't gone off from the report. Is there anything more that you did? Like, chnaged some settings or something?
Would be great if you could add the pbix file as an attachment.