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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
AmazingRandom
Helper II
Helper II

Table not filtering out when slicer is selected

I am currently working on a project that I just got handed from someone else, as that person left. One of the feedbacks that was given was to fix a table that was not filtering out the other values. Which I found weird given the table should already do that. I don't really have an idea as to why this is happening. Since the table has confidential data I'll try to illustarte below:

Say we have this table:

NameType

Value

ExampleType112%
EjemploType235%
BeispielType3

18%

 

And a slicer for Name and Type, however if I select Type 3, all it is doing is the following:

 

NameTypeValue
BeispielType318%
ExampleType112%
EjemploType235%

 

All it is doing is just put the selected subcategory on top, but it is not filtering out the other options, how can I fix this? Thanks in advance!

2 ACCEPTED SOLUTIONS
Daniel29195
Super User
Super User

Hello @AmazingRandom 

 

 there could be many reasons why it "isnt filtering" , 

possible reasons : 
DAX code 

model relations . 

turning off interaction between visuals .

...

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

 

View solution in original post

Anonymous
Not applicable

Hi @AmazingRandom 


Please verify that there are active relationships between the tables involved. Make sure the relationships are correctly set up, especially the cardinality properties (e.g., one-to-many).

Instead of relying solely on slicers, consider using visual level filters directly on the table visualization to check if the issue appear again.

 

If this can't help, please share your data(without sensitive data) or you can create sample data so that we can help you better.

 

Best Regards,

Zhengdong Xu

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @AmazingRandom 


Please verify that there are active relationships between the tables involved. Make sure the relationships are correctly set up, especially the cardinality properties (e.g., one-to-many).

Instead of relying solely on slicers, consider using visual level filters directly on the table visualization to check if the issue appear again.

 

If this can't help, please share your data(without sensitive data) or you can create sample data so that we can help you better.

 

Best Regards,

Zhengdong Xu

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

Daniel29195
Super User
Super User

Hello @AmazingRandom 

 

 there could be many reasons why it "isnt filtering" , 

possible reasons : 
DAX code 

model relations . 

turning off interaction between visuals .

...

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.