The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
Name | Type | Value |
Example | Type1 | 12% |
Ejemplo | Type2 | 35% |
Beispiel | Type3 | 18% |
And a slicer for Name and Type, however if I select Type 3, all it is doing is the following:
Name | Type | Value |
Beispiel | Type3 | 18% |
Example | Type1 | 12% |
Ejemplo | Type2 | 35% |
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!
Solved! Go to Solution.
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! 🤠
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.
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.
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! 🤠