Forum Discussion
blank values with relationship
Hello All, I have a dataset with 3 tables: Calls (containing calls info and phone number) Line_num ( phone number, site_id) Site (site_id, site address) and all the relationships working fine, ...
- Anonymous That solution will work, only potential issue is that Joins (or merge in Power Query language) can drastically slow down the refresh time of your query when compared to using the relationships. This usually isn't a problem though, especially if you can set an automatic refresh to load overnight.
Great troubleshooting and glad I could inspire a solution for you! Please mark this post as solved so others can easily find the answer.
Cheers!
Allison
thanks for the reply,
actually the Line and site table does not have empty or blank rows, the difference coming from that main table which is call table does have more records than the line/site table which is ok with me but for those not matching values I want to show them as not available.
here is how the relationship works:
from Call table to line to site:
1- call.number =line.number
2.line.site_id=site.Site_Id
I've created those relations using the relationship tab not joining any tables from query editor.
AllisonKennedy
Community Champion
Community ChampionAnonymous
Thanks for explaining the data, this is helpful.
Yes, I was not expecting any blank values in the line or site tables. What is the Call.number for the additional records which are in the call table but not in the line table? As you said, it is fine to have these additional records, but if you don't have them in the line table it will always show as blank in the visual. There is currently no way to change what the 'blank' displays as, so you need to fix the problem at its source. This means you need to provide an extra record in both the line and site tables that will match the additional records in the call table.
Please can you add call.number to your table visual before site (so the order should be Number of Calls, Call.Number, Site) and let me know if the Call.Number is blank or if it has lots of different numbers, or just one number for the rows where Site is blank.
Thanks for explaining the data, this is helpful.
Yes, I was not expecting any blank values in the line or site tables. What is the Call.number for the additional records which are in the call table but not in the line table? As you said, it is fine to have these additional records, but if you don't have them in the line table it will always show as blank in the visual. There is currently no way to change what the 'blank' displays as, so you need to fix the problem at its source. This means you need to provide an extra record in both the line and site tables that will match the additional records in the call table.
Please can you add call.number to your table visual before site (so the order should be Number of Calls, Call.Number, Site) and let me know if the Call.Number is blank or if it has lots of different numbers, or just one number for the rows where Site is blank.