Forum Discussion
Hide Columns with zero value in Matrix
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...
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.
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.