Forum Discussion
Relationship issue
I have two table that both have country codes in them. I want to return the country name but when I add this to a visualisation it returns all the countries and not countries with data against it.
Here is the relationship
Both columns are set as text
Hi Anonymous ,
I have created the following sample data.
When adding the fields of the 'InteractiveSignIns' table and the [Country] field of the 'CountryCodes' table to the visual, it will only show the rows that are not empty.
If you want to show only the countries that exist in the 'CountryCodes' table and the 'InteractiveSignIns' table, then try the following visual-level filter.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , Put these columns into a table visual. if you get null on the country code side, it means those codes are missing from the table.
Hi Anonymous ,
I have created the following sample data.
When adding the fields of the 'InteractiveSignIns' table and the [Country] field of the 'CountryCodes' table to the visual, it will only show the rows that are not empty.
If you want to show only the countries that exist in the 'CountryCodes' table and the 'InteractiveSignIns' table, then try the following visual-level filter.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
