Forum Discussion
Hide 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.
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.