Filter not transitioning between related tables in 1-1 relationship

[NAOS]

Hi,

I have a composite model and I'm having problems to get the filter through the relationship between the tables.

Please see the image below for reference.

If I try to apply a filter from either table the visuals go blank. Same outcome if I try to combine values from both tables.

I am sure I'm missing something but could someone explain me what that is?

I know I haven't provided lots of details so if you have any questions I'll be happy to answer them.

Thank you,

[NAOS]

Hi @v-yadongf-msft ,

There was a problem in the dataset from which I was getting the table in DirectQuery. I only found out today after reviewing the dataset myself.

No issues from PBI side. If you have any way of unpublishing this thread please let me know.

Thank you

[v-yadongf-msft]

Hi @NAOS ,

It sounds weird.

In order to better understanding your demands and give the right solution, could you please tell me what your steps are, the table's connection mode and share with me some screenshots of your data after hiding sensitive information.

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.