The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
@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.
Proud to be a 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.
Proud to be a Super User! |
|
Ah cool. I already have such a measure. I just filtered it to be less than zero. Grand, thank you very much!