Field showing as 'Blank' when applying filter in live connection

[NASMN]

Hi everyone, 

I have multiple tables where everything is linked as a one:many to a master table based on a PK ID. When I apply a filter using the PK from the master table certain visuals/cards show as 'blank'. I was able to narrow down the specific tables that are having this issue, however the odd thing is when I create the exact same relationships with a static database I don't have any problems with any of the visuals. Has anyone had this problem with a live connection? I'm not aware of any changes in structure happening in the backend of the architecture with SQL that would impact the relationship of the model.

Any help is appreciated!

[jennratten]

@NASMN To me this sounds like a difference in values or data type rather than a relationship/structure issue. 

Process of elimination:

• If the visual is always blank regardless of which value from the dim table is selected then that eludes to more of a data type/formatting issue and could still also be a difference in values.
• If the visual sometimes returns a value and sometimes is blank then it is likely a scenario in which the dim value doesn't have a corresponding output from the fact table.
• Make sure the data types and formatting of the dim table PK and the fact table FK are the same.
• Add a column to the fact table to return a field from the related dim table (to see whether or not anything is populated).
• Go to Power Query and test the same.  DAX is not a case-sensitive language and trailing white-space characters are automaticially trimmed when the data is loaded to the model, but there could still be differences unaccounted for.