Table visualization with fields from two source tables showing some existing values as blanks

[botayone]

In the 4 columns below, columns "Account Manager", "Customer Email", and "Reachout Status" are read from Table A.

"March 2021 Response" is read from Table B. and Table A and B have a relationship on the "Customer Email" column.

If the columns are in this order, things are fine.

This shows that Aaron Baxter has two accounts.  One of the accounts reponded to March 2021 survey and the other account did not respond so the "March 2021 Response" column is blank.

When the columns are reordered, with "March 2021 Response" moving ahead of "Reachout Status", the value of "Phone # unknown" disappears.

When column "March 2021 Response" is moved one more column to the left, the entire row for caxy.com disappears.

But when the "Customer Email" and "Account Manager" columns switch positions, and "March 2021 Response" remains as the second column, the caxy.com row comes back but missing values for both the "Account Manager" and "Reachout Status".

Why is it necessary to display all Table A columns first before displaying Table B columns?  And more importantly, how to fix things so that column order wouldn't impact the display values?  Thanks!  

[Anonymous]

Hi @botayone 
I am so glad that you can find the solution , please consider Accept it as the solution to help the other members find it more quickly.

Best Regards
Community Support Team _ Ailsa Tao

[Ashish_Mathur]

Hi,

Can you share the download link of your PBI file?

[botayone · Accepted solution]

Hi Ashish.  Thank you for your reply.  It turns out that one of the suggested threads found by the site explained the issue about there being fact tables and dimension tables.  I believe that applies to my situation and as such my inquiry can be closed.

Solved: Table visualization doesn't show data after blanks... - Microsoft Power BI Community