Table Visualization - Data Not Populating in Columns to the Right After Column = Blank

[Anonymous]

Hi all.

I've got a data display issue that I can't figure out how to fix. I've Googled and searched these forums and come up empty. Can someone please take a look?

The issue is with a table visualization. When I pull in just non-numerical columns that are all populated it works fine (displays the LT 1 Amount = $0, Issued Diff = $0, in this case Bank Amount truly is blank for the rows):

When I add the Statement Date column, if the value for the row = blank it does not return anything to the right, even if that column does contain a value (Explanation is now blank, even though the source data contains a value):

Order of columns seems to matter, if I switch the postion of Explanation and Statement Date the Explanation goes back to populating, but the Amount columns (LT 1 Amount and Issue Diff) are still blank, instead of the $0 I expect to see:

Moving Statement Date to the last column does not fix LT1 Amount and Issue Diff:

All non-numerical values do have "Show items with no data" selected (it's not an option for the numerical values):

This is what I want to see:

These are my relationships:

Any tips on how to fix this? 

Thanks!

[Anonymous]

Hi @Anonymous ,

If you can, please share your pbix to me with OneDrive. Remember to hide your sensitive information.

Best Regards,

Stephen Tao

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

[Anonymous]

Hi @Anonymous ,

Try to change the cardinality option to many-to-many.

Best Regards,

Stephen Tao

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

[Anonymous]

Hi Stephen.

Thank you for your response. Unfortuantely, changing the cardinality option to many-to-many did not fix the issue. 

Any other ideas?

Thanks

Emily