Hide row generated from visual calculations in matrix visual

[Kalin_Iliev]

Hi all!

I have a matrix visual where with the help of visual calculations fearure a Demand Comparison is called in the matrix. The problem is how the first blank row of this can be hidden?

[v-saisrao-msft]

Hi @Kalin_Iliev,

Have you had a chance to review the solution we shared by @anilgavhane @rohit1991 @mh2587 ? If the issue persists, feel free to reply so we can help further.

Thank you.

[anilgavhane · Accepted solution]

@Kalin_Iliev 

Option 1: Use a Visual-Level Filter

If the blank row has a total but no monthly values, you can filter it out by checking for blanks in one of the month columns:

1. Select the matrix visual.
2. In the Filters pane, add a filter on a representative measure (e.g., Demand for January).
3. Set the filter to “is not blank” or “greater than 0”.

This hides rows where that measure is blank or zero.

Option 2: Adjust the DAX Measure

Modify your measure to return BLANK() when the row shouldn't be shown. For example:

Demand Comparison = IF( HASONEVALUE('Date'[Month]) && [YourLogicHere], [Demand], BLANK() )

Then use the same visual-level filter to exclude blank values.

 Option 3: Use a Calculated Column or Table Filter

If the row is coming from a calculated table or column, you can pre-filter it:

FilteredTable = FILTER( OriginalTable, NOT(ISBLANK([Demand])) )

Use this filtered table in your matrix visual instead.

Option 4: Hide Totals for Blank Rows (Advanced)

If the row only shows a total and no monthly values, you can suppress the total using DAX:

Demand Comparison = IF( COUNTROWS(VALUES('Date'[Month])) = 0, BLANK(), [Demand] )

This prevents the total from showing unless there are monthly values.

[rohit1991]

Hi @Kalin_Iliev 

1.Add a visual filter:

• In the Filters pane, drag the same field (like WeekYear or Demand Comparison).

• Set the filter to “is not blank” ,this hides the empty row.

2.Fix it in your DAX measure:

Demand Comparison =
IF(
    ISBLANK([Your Measure]),
    BLANK(),
    [Your Measure]
)

This stops Power BI from creating rows with no values.

3.Turn off “Show items with no data”:

• In the matrix field settings, make sure Show items with no data is off.

[Kalin_Iliev]

Hi rohit1991,
The suggested solution is not working because the visual calculation "Demand Comparison" can't be called in a regular measure because it contains PREVIOUS function, available only for vusual calculations, it also can't participate in filters section. Also the menu item "Show items with no data" is greyed and can not be used.

[mh2587]

If you checked the "Show items with no data" remove that from dimension column in dropdown options