Forum Discussion
Advocate Irelationship create a blank with no reason: data is consistent
Hi MarcoFogale ,
Yes,when you create relationships,those only have values on one side,the other side will return blank.Just as below:
A workaround for you:
Select the visual>go to filters pane>choose "advanced filtering">"is not blank",then "apply":
And you will see:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Advocate IOk... I finally figure out what happen to my slicer.... but I still don't know how to deal with this problem.
This is my whole model:
With these relationships, everything works fine and all the slicers, taken from the dimensions tables show no blanks:
If I add the relationship with the Dates table (that I created following the Mastering DAX video course from SQLBI, and contains all the dates from January 1st to Dec 31th) I have blanks on the others tables because, obviously, not all day appears in the "Sales" table.
It's a relief, I don't have to start everything over. But... how do you deal with these blanks, created out of the date table? Is there a better practice to adopt to have a date table with all dates, in order to take advantage of time intelligence functions, avoiding at the same time these blanks on slicers that could lead to doubts about data consistency and reliability?
Community SupportHi MarcoFogale ,
Yes,when you create relationships,those only have values on one side,the other side will return blank.Just as below:
A workaround for you:
Select the visual>go to filters pane>choose "advanced filtering">"is not blank",then "apply":
And you will see:
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!