Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Missing data in Table visual, Dates with relationships

Good morning all,   I have an issue with showing data in my Table visual.   My column charts, shows me the wright numbers of transports. This works fine. Orange = Loadings Blue = Unloading Gre...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    thank you for your detailed reply!

    based on your screenshots above, we can see status used in two visuals are different, the status in visual2 comes from Transport, and in visual2 comes form 3 measures, 

        

    So I think this is may not only related to your Date filter, but also related to the Status values. but based on your discription, filter also works on visual1, and visual1 works OK, there are three states in visual1.

    so I guess it should not be the problem caused by filter. It may be caused by some values in visual2, try to select this and see the result.

    If problem still exists, could you share your PBI file after removing sensitive information?

     

     

     

    Best Regards,

    Community Support Team _ Tang

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

     

  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi Anonymous 

    Have you solved your problem? If yes, kindly accept it as the solution. Otherwise, please provide more details about your problem so that we can work on it further. Thanks.

     

    Best Regards,

    Community Support Team _ Tang

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

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous 

Are you sure there is only one status in the table visual? Sort the transport column or scroll down to see if it is missed. 

If there is really one status in the table visual, we need to see where the data in 2 visuals come from.

But from your screenshots, it's hard to judge which tables the data in visual comes from. I guess there is no relationship between the data in 2 visuals. So they have three statuses in one visual and only one status in the other.

So the reason maybe that the relation between "Date Table" and the "Loading Date" will filter the column [Transport]. 

 

 

Best Regards,

Community Support Team _ Tang

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello v-xiaotang,

 

Thanks for your reply.

 

It is correct that i have a relationship with the Data Table.

Date Table >> Loading Date

Date Table >> Unloading Date

Date Table >> Drop-off Date

 

My filter is made by the the Date from the Date Table.

 

My first Visual, which shows the Transports, is made bij:

Loading Date

Unloading Date

Drop-off Date

 

Axis = Date from Date Table

Values = Loading Date, Unloading Date, and Drop-off Date

All with the formule:

Unieke Telling Ladingen = CALCULATE(DISTINCTCOUNTNOBLANK(TblDataInput[Ordernr]),TblDataInput[Lading]="Ja",TblDataInput[RitStatus]="RIT_VLTD",USERELATIONSHIP(TblDatum[Date],TblDataInput[Laad Datum]))

 

 

 

The second value which only shows me the loadings:

Contains also the column "Loading Date" and "Unloading Date.

 

So i supose, this should be the connection between the 2 visuals.