Forum Discussion
How to hide rows where columns are empty in a Matrix visual
Microsoft EmployeeYou 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
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!