Forum Discussion
How to hide rows where columns are empty in a Matrix visual
mahoneypat in my matrix above both V1 and V2 are visuals. so how do I filter that with multiple measures??
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