0s to be on the top or display only values with 0

[rodri2196]

Hi Experts,

I am currently finding it difficult to find a solution to my problem.

I have 2 matrices on power bi.
Matrix 1 is the summary matrix and matrix 2 is the in depth version.

I am using the summary matrix  to filter data onto the bottom detailed matrix.

The problem I am facing is that I can manage to display only the details that I want to filter out. It is giving me all the data which I dont need to visualise.

This is my summary Matrix. So I usually Click on any of the gender rows.

  


So when I click on the genders, I need the rows (highlighted in red) with 0s to be on top rather than scattered throughout the matrix.
The dates are relative dates for the enxt 6 months.


Sorry to black out the data.
Is there a way this is acheivable. Maybe through dax or something?

[amitchandak]

@rodri2196 , Matrix can only sort on the Row field or On Column totals ( of values across Column fields)  , so you can sort on column totals if that can help.

You can log and vote for an idea if needed - https://ideas.powerbi.com/ideas/

[rodri2196]

Hi @amitchandak 
Thank you soo much for your response

Is there a way where I can delete other rows and just display  the rows that have 0s present in them?