Forum Discussion
Visual inconsistent in showing data
Hello all,
I have an issue within Power BI desktop where my table does not show data although it is expected.
I have added screenshots for clarification.
I created a table with 3 columns (screenshot 1)
The data comes from 3 different tables (screenshot tables)
- containernumber from WB order table
- PO_NO from jc_po_to_data table
- Comments from container comments table
There is one active filter for containernumber (screenshot filters)
which results in one row with data (see screenshot 1 again) with
containernumber filled --> correct
PO_NO blank --> correct
comments blank --> incorrect becasue for this containernumer a comment should be available
The vsisual is inconsistent in showing this note. When I take out the PO_NO column, the comment is shown (screenshot 2) which is correct.
However, when I add the PO_NO column again, the comment remains shown (screenshot 3).
Does anyone have an idea why the comment is not shown in the original table. I have checked if all fields have the 'show items with no data settings, and they are the same.
screenshot 1 - starting table
tables
filters
screenshot 2 - take out PO-no
screenshot 3 - add PO-NO again
show items with no data
2 Replies
- v-juanli-msftCommunity Support
Hi Anonymous
It may be caused by the wrong relationships among three tables.
Please show me an example data and relationships you create among three tables.
Best Regards
Maggie
- AnonymousNot applicable
Attached you may find the relationships among the three tables.
The table 'WB Order' contains only unique orderID's, however in the table 'jc_po_TODATA' a specific orderID occur in mutliple rows.
The table 'WB Order' contains specific ContainerNumbers which occur in multiple rows, the table 'Container comments' contains only unique values of the Container number.