Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
@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?
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |