Dashboard

[NZannikos_]

Hi,

I have a problem in which the dates of the last week from a related table dont show up when this table is related with the calendar table.

All dates both in Calendar and in the related table are in date format.

Calendar table dates are greater from the related table. The stopping date of Calendar is greater compared to the related table.

When using in a graph only the date from the related table the data are shown correctly, but as soon as as I relate it with the calendar table the last week of the data from the related table are missing.

Any ideas?

Regards,

Nikolas

[Anonymous · Accepted solution]

Hi @NZannikos_ ,

There could be several possible reasons for this issue, such as:

• The relationship between the calendar table and the related table is not set up correctly. You need to make sure that the relationship is one-to-many, single direction, and based on the date columns in both tables. You can check and edit the relationship in the model view of Power BI Desktop.
• The date column in the related table has some missing or invalid values that prevent the relationship from working properly. You can use the query editor to inspect and clean your data, such as filling in missing dates or converting text values to date format.
• The date filter in your graph is not applied correctly. You need to make sure that the filter is using the date column from the calendar table, not the related table, and that it covers the entire range of dates that you want to show.

powerbi - Fill in Missing Dates Power BI - Stack Overflow

Creating Calendar Table in Power BI using DAX Functions - RADACAD

How to Get Your Question Answered Quickly 

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

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