Forum Discussion

Kalin_Iliev's avatar
Kalin_Iliev
Frequent Visitor
10 months ago
Solved

Hide row generated from visual calculations in matrix visual

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? ...
Need Help
  • anilgavhane's avatar
    anilgavhane
    10 months ago

    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's avatar
rohit1991
Icon for Super User rankSuper User
10 months ago

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's avatar
Kalin_Iliev
Frequent Visitor
10 months ago

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.