Suppressing "Blank" Rows (formatting issue?)

Hi delish_hins ,

The issue you're facing stems from the way Power BI handles custom formatting strings and data visibility in matrix visualizations. When you use a format expression like #,#,;(#,#,); to display values in thousands, Power BI does not treat values between -999 and 999 as blank. Instead, it formats them into visually empty cells, but the underlying data is still present. This is why rows with small values still appear in your matrix. To resolve this, you can create a custom measure that explicitly filters out rows where the rounded value is effectively zero after dividing by 1,000.

Here's an example of a measure you can use:

Display Value = 
VAR RoundedValue = ROUND(SUM(Table[YourValueColumn]) / 1000, 0)
RETURN
IF(ABS(RoundedValue) > 0, RoundedValue, BLANK())

In this measure, the values are first divided by 1,000 and then rounded to the nearest integer using ROUND. The IF statement ensures that only values outside the range of -999 to 999 are displayed, while smaller values are returned as BLANK(). This ensures rows with effectively zero values are not visible in the matrix.

Once this measure is added to your matrix visualization, it will only display rows where the rounded value is non-zero, addressing your issue. Additionally, make sure the "Show items with no data" option is disabled in the matrix visual settings, as this can force rows to appear even if their values are blank. This approach resolves the formatting issue while maintaining best practices for calculations and visualization.

Best regards,