Forum Discussion
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?
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:
- Select the matrix visual.
- In the Filters pane, add a filter on a representative measure (e.g., Demand for January).
- 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.
5 Replies
rohit1991Super User
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.
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
- anilgavhane
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:
- Select the matrix visual.
- In the Filters pane, add a filter on a representative measure (e.g., Demand for January).
- 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.
v-saisrao-msftCommunity Support
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.
