Forum Discussion
Values with no corresponding Date
Those values have a date that is blank or outside the range of the date table. If the date table only has dates from 2019 and 2020, but those records are 2017 or 2021, you'll see this.
Remember that relationships in Power BI are not joins, they are filter relationships, but they won't prevent data that doesn't match any of the tables from appearing, they manifest as white space like this.
Those values have a date that is blank or outside the range of the date table. If the date table only has dates from 2019 and 2020, but those records are 2017 or 2021, you'll see this.
Remember that relationships in Power BI are not joins, they are filter relationships, but they won't prevent data that doesn't match any of the tables from appearing, they manifest as white space like this.
Thank you very much!
Glad to help shihanesanjo . Can you mark the post(s) that helped as the solution so others can find the answer if they have a similar question?