Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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-msft's avatar
    v-juanli-msft
    Community 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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-juanli-msft 

      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.