Forum Discussion
Helper IVHide a row in Matrix
Hi han_rj ,
To hide rows in your Power BI matrix where Sales_2023 is 0 and the following years have no values ("-"), create a new measure like this:Show Row = IF ( [Sales_2023] <> 0 || [Sales_2024] <> "-" || [Sales_2025] <> "-", 1, 0 )
Add this Show Row measure to your matrix as a visual-level filter and set it to show only when value is 1. This will hide rows where 2023 is 0 and the other years are blanks/"-".Power BI doesn’t support direct row hiding, but filtering using a measure like this achieves the desired effect.
Super UserStep 1: Create the New Filter Measure
First, create the DAX measure that will check for your condition.
In Power BI Desktop, go to the Modeling tab or right-click your table in the Data pane.
Select New Measure.
Copy and paste the following DAX formula into the formula bar:
Filter Rows =
VAR Sales2023 = SUM(Sheet1[2023 Sales])
VAR Sales2024 = SUM(Sheet1[2024 Sales])
VAR Sales2025 = SUM(Sheet1[2025 Sales])
RETURN
IF(
AND(Sales2023 = 0, ISBLANK(Sales2024), ISBLANK(Sales2025)),
0,
1
)
This code checks each row to see if Sales in 2023 are zero AND sales in both 2024 and 2025 are blank. It assigns 0 to these specific rows and 1 to all others.
Step 2: Apply the Measure as a Filter
Click on your Matrix visual to select it.
Go to the Filters pane and find the Filters on this visual section.
From the Data pane, drag your new measure, Filter Rows, into the "Filters on this visual" area.
A new filter card will appear. Set the Show items when the value dropdown to is and type 1 in the box.
Click Apply filter.
If this explanation and solution resolve your issue, please like and accept the solution.