Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
AC23VM
Helper II
Helper II

Matrix with blank values - hiding blanks?

Hi there.  Just a quick question.  I have a matrix that displays a a set of data, say A-E.  In December, there were no instances of A.  But regardless if I have a slicer for December, the matrix still shows a row for A, albeit one with zero values.  If I go into the filter pane, A isn't there (because it isn't in December) so I can't untick the box to not show it.  Is there a way around this?  Ideally, I'd like these rows with zero values not to show up at all.

 

 

1 ACCEPTED SOLUTION
bhanu_gautam
Super User
Super User

@AC23VM , To hide rows with zero values in your matrix, you can use a measure to filter out those rows.

 

Create a measure that calculates the sum of the values for each row.

TotalSales = SUM('Sales'[Amount])

 

Use this measure to filter out rows with zero values. You can do this by adding a visual-level filter to your matrix visual. Here’s how:
Select your matrix visual.
In the Visualizations pane, drag the measure you created (e.g., TotalSales) to the Filters on this visual section.
Set the filter condition to show only rows where the measure is greater than zero.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

2 REPLIES 2
bhanu_gautam
Super User
Super User

@AC23VM , To hide rows with zero values in your matrix, you can use a measure to filter out those rows.

 

Create a measure that calculates the sum of the values for each row.

TotalSales = SUM('Sales'[Amount])

 

Use this measure to filter out rows with zero values. You can do this by adding a visual-level filter to your matrix visual. Here’s how:
Select your matrix visual.
In the Visualizations pane, drag the measure you created (e.g., TotalSales) to the Filters on this visual section.
Set the filter condition to show only rows where the measure is greater than zero.




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Ah cool.  I already have such a measure.  I just filtered it to be less than zero.  Grand, thank you very much!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors