Forum Discussion
Avoiding blank rows in Matrix
Hi gfdytr4
Thank you for reaching out to the community!
Power BI Matrix visuals do not automatically remove rows with blanks when you're using columns (not measures) in the Values field. Unfortunately, there's no built-in way to conditionally hide rows based on blank column values when you're using actual columns instead of measures.
The common workaround using a Has Value measure only works when you're using measures in the Values field, not raw columns. Since you're using a column, Power BI renders each row even if all column values are blank, and filtering using SELECTEDVALUE() doesn’t work as expected.
As of now, there's no documented method from Microsoft to conditionally hide rows in this scenario. If conditional formatting is important and you want to keep individual formatting, one approach would be to reshape your data model in Power Query to remove rows that have all blanks before loading to the model.
I hope this clarifies the limitation. If this helped, kindly mark it as the accepted solution to help others in the community.Best regards,
Cheri Srikanth
Power BI & Fabric Community Support Team
Hi gfdytr4
Thank you for reaching out to the community!
Power BI Matrix visuals do not automatically remove rows with blanks when you're using columns (not measures) in the Values field. Unfortunately, there's no built-in way to conditionally hide rows based on blank column values when you're using actual columns instead of measures.
The common workaround using a Has Value measure only works when you're using measures in the Values field, not raw columns. Since you're using a column, Power BI renders each row even if all column values are blank, and filtering using SELECTEDVALUE() doesn’t work as expected.
As of now, there's no documented method from Microsoft to conditionally hide rows in this scenario. If conditional formatting is important and you want to keep individual formatting, one approach would be to reshape your data model in Power Query to remove rows that have all blanks before loading to the model.
I hope this clarifies the limitation. If this helped, kindly mark it as the accepted solution to help others in the community.
Best regards,
Cheri Srikanth
Power BI & Fabric Community Support Team