"Blank" data field in a filter

[Syndicate_Admin]

Hello to the community and thanks in advance for the help.

The status of my data model is as follows:

Related tables:

In a data visualization I created a filter in which "(Blank)" appears. I understand that it means that in that field there is "blank" data. However, when I choose the "Blank" in the filter there is no data. I have reviewed my tables and find no blank data from that field or in the filter table in related tables that have that field:

How can I locate what data is blank to correct it? In the Power Query Editor with its field analysis no blank data appears in any of the tables of that related field that is called "Game".

Greetings.

[Syndicate_Admin]

Hello good afternoon, sorry, I have the same problem you think you can help me know how to solve it?

[amitchandak · Accepted solution]

@Syndicate_Admin , Blank data in 1 -M Join table can also be because there is some value on many side.

Plot this table with a key columns from joined fact/s one by one and check for any missing value

refer if needed

https://www.youtube.com/watch?v=23qemkDqMVY

[Syndicate_Admin]

Hello:

Found the problem. This was an error in table relationships. I hadn't checked all the related tables if any fields were blank.

Thanks for the reply.