Forum Discussion
How to hide rows where columns are empty in a Matrix visual
Microsoft EmployeeYou 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
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-msftCommunity Support
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,
KellyDid I answer your question? Mark my post as a solution!
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 ,
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,
KellyDid I answer your question? Mark my post as a solution!