Forum Discussion

NZannikos_'s avatar
NZannikos_
New Member
2 years ago
Solved

Dashboard

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

Dashboards
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.