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

[baileymae]

So I have two tables that have a relationship and I want to show a Table Visual of all the rows in the first table that are not at the second table.

I thought the solution is in this post that I only need to "Show items with no data" then I can filter those that are not blank but for some reason it is not working. I'll attach a sample of what is going on:

This is the output after making a relationship and adding the columns

ID (From Table 1)	Number (From Table 2)
A	11
B
C
D	11

I wanted it to look like:

ID (From Table 1)	Number (From Table 2)
B
C

But when I use this filter:

it just shows:

ID (From Table 1)

Number (From Table 2)

and if this filter:

it shows correct like this:

ID (From Table 1)	Number (From Table 2)
A	11
D	11

[V-yubandi-msft]

Hi @baileymae ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft]

Hi @baileymae ,

We haven’t received a response yet and want to ensure the solution met your needs. If you need any further assistance, feel free to reach out we’d be happy to help. If everything is working as expected, kindly mark it as Accepted as solution.

Thank You.

[V-yubandi-msft]

Hi @baileymae ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[LED_General]

Hello,

could you please specify which column is being filtered.

[baileymae]

I want to filter all the blanks in the Number Column which shows blank since there's no match in the relationship in the ID Key because I have the "Show items with no data" checked.

[V-yubandi-msft · Accepted solution]

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'.

[baileymae]

I forgot to add that I successfully done this using a Merge in Power Query but I want to hopefully do this using only Relationships to lessen my Merges.