Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rodri2196
Frequent Visitor

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

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.

rodri2196_0-1683763634039.png

 

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


rodri2196_1-1683763970301.png

 


  


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?

 

2 REPLIES 2
amitchandak
Super User
Super User

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

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors