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 ta...
  • 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.