"Advanced Filtering: Show items when value is not blank" is not working properly

Hi baileymae ,

To filter out the blanks in the Number column caused by unmatched relationships in the ID Key while keeping the  Show items with no data  option enabled, you can follow these steps.

1. Create a DAX measure to check for blanks in the Number column, helping you identify and filter out these values.

2. Use the Filters pane in your visual to exclude blanks directly from the Number column.

3. Verify the relationship settings for the ID Key between tables, ensuring the cross filter direction is correct and the linked columns match properly to avoid unnecessary blanks.

4. Create a table visual displaying the ID Key and Number columns from both related tables side by side to identify mismatches or gaps, making troubleshooting easier.

Also, I found a community discussion that might be helpful
Solved: Show Blank Data when Nothing is filtered - Microsoft Fabric Community

If my response solved your query, please mark it as the Accepted solution to help others find it easily. And if my answer was helpful, I'd really appreciate a 'Kudos'.