Forum Discussion
Dashboard
- Anonymous2 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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.