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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors