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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Jermain
Frequent Visitor

Don's show value (in row) if SUM total is 0 in matrix

Hello,

 

I have a matrix where i want to show the overdue vendors.

 

When the SUM = 0,00 i don't want to show the Vendor (rows) in the matrix. See the picture below.

 

Naamloos.png

 

I have tried diffrent solutions without result.

 

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@Jermain

 

If you just need to remove rows with "Total Sum" is 0, you can add a Visual Level Filter on that Value field.

 

24.PNG

 

23.PNG

 

Regards,

When i do that all amounts greater then 0 are filtered out also the amount that i need tot calculate the SUM total. 

 

This solutions does not work.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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