Forum Discussion
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
Green = Emptys
Only as you can see, the Table shows me only the "Loadings".
So i miss the "Unloadings" and the "Shunts" in my Table.
When i delelete the relation between my "Date Table" and the "Loading Date" (Yellow) the table does show me every Transport.
I have my Date filter on the first page.
This filter is a hierarchy of the Date table.
Do you have any idea how i can solve this issue?
Gr alfons
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.
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.
8 Replies
v-xiaotangCommunity Support
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.
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.
- v-xiaotang
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
Hi Anonymous
you can delete sensitive information from model, or just create a sample file without 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
Hi Anonymous
FYI:
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
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.