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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
maciekkkm
New Member

How to ignore filter from a column in matrix

Hi,

I have the following question.

Is there a possibility to manipulate filters, in this case from a date column?
I would like to have "total sold" only displaed once at the end of a matrix, not per each months, while "total baked" should be splited as it is. I have tried will a combination of "remove filters" etc, however, it didn't work.

Thanks in advance.

 

maciekkkm_0-1719222556930.png

 

1 REPLY 1
Anonymous
Not applicable

Hi @maciekkkm 

 

This has to do with the design of power bi, where you can't display "total sold" only once at the end of the matrix.

 

You might consider creating a calculated measure that adds up the "Total Sales" for all months. This measure is then placed outside the matrix or only displayed in the last individual visual object.

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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