How to hide rows where columns are empty in a Matrix visual

[Anonymous]

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

[mahoneypat]

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

[Anonymous]

@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

[Anonymous]

I am not sure what you meant here? you are saying to write two different measure like 
CALCULATE([V1,V2], Table[Version] = "Version from Plant B") 

CALCULATE([V1,V2], Table[Version] = "Version from Plant A") 

and then put these two measures in Filter for the matrix Visual?

Can you please provide the Dax where I can have a check on multiple measures.. i dont think above way is correct

[v-kelly-msft]

Hi  @Anonymous ,

Go to filter pane>select all measures are not blank,just like:

And you will see:

For my related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

@v-kelly-msft I dont know how it works for you but I did same and I still see empty rows

[v-kelly-msft]

Hi  @Anonymous ,

Have you solved the issue?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

No it does not work. I didnt get time to upload the pbix as there are lot of sensitive data but will provide one soon

[v-kelly-msft]

Hi  @Anonymous ,

You could check my .pbix file for details or could you pls upload your .pbix file for test?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@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?

[Anonymous]

@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.