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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
robertobrsp
Frequent Visitor

REMOVING LINE LEVEL FILTER IN VISUAL MATRIX

Hi, a simple question! I need to remove the row-level filter in the matrix visual. I've tried using (ALL, ALLEXCEPT) and it didn't work. Example below:
RESULT
resultresult
expected outcome
result outcome.jpg

2 REPLIES 2
Anonymous
Not applicable

Hi @robertobrsp 

You can add a measure formula with an if statement to check the current value and return tag . Please refer to the link below , hope it will help you .

https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/ 

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@robertobrsp , Simply use All()

or

all(Tablename)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors