Forum Discussion
How to hide rows where columns are empty in a Matrix visual
I have a matrix in below format and I would like to hide those ids from the rows where values are not present in each column.. How can I do it??
For eg: below is a (Matrix visual from Power Bi) in below table Under Column "Version" we have columns "Version from plant A" and "Version from plant B" and both columns have values V1 and V2. Now in below reading row, test 2 do not have any reading in Version from Plant B column and hence i would like row test2 to be removed but keep those rows who has reading from both Version From Plant A and Version From Plant B columns
| Version(Column) | Version From Plant A | Version from plant B |
| Name(Row) | V1 | V2 | V1 | V2 |
| test 1 | 23 | 22 | 98 | 2 |
| test 2 | 87 | 22 |
11 Replies
- amitchandak
Super User
Anonymous , if all the measures on a row are blank then power will hide that row automatically.
What are the measures and columns(Pivot) used in case?
amitchandak no it does not hide if all the measures for one of the column is blank. What do you mean by What measures and pivot? all the values here are measures.
- mahoneypat
Microsoft Employee
You could try to add a new measure like CALCULATE([YourMeasure], Table[Version] = "Plant B") and use it as a visual level filter on that matrix, and filter it to where it is not blank.
Pat
mahoneypat in my matrix above both V1 and V2 are visuals. so how do I filter that with multiple measures??
- mahoneypat
You can highlight each visual and add the measures to the Filter Panel, or you can write a single measure that checks if any of the measures is blank and use just that one.
Add a filter to a report in Power BI - Power BI | Microsoft Docs
Pat
