Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi theres.
I'm having issues with the relationship between date table and 'ResultadosEncuesta' table, as you can see I have 60 surveys with no dates in the matrix but in the fact table they have a date correctly.
Here is the model view map
Here is the File sample
I'll appreciate the explanation since I want to keep learning everyday.
Solved! Go to Solution.
Finally I solve it, Looks like I was using the Userrelationship function incorrectly in the measures, at this point looks greate.
Finally I solve it, Looks like I was using the Userrelationship function incorrectly in the measures, at this point looks greate.
Hi @dustdaniel
Your file needs permission to access. That aside, the common reason why the blank is there are dates in your fact table that are not in the calendar table. Try adding the date from the fact table to the viz as well. Some will not have a match from the calendar.
Proud to be a Super User!
In this case i think is not what you mentioned. In the next screenshot, the table on the left includes the dates from the fact table and there is only one row for Jan/01st but if I use the Date from date table as per on the right, its showing 3 rows that actually are from different dates
PD: kindly reminder that the sample file should be with no restriction at this moment - Thanks
I'm getting closer, just noticed that the issue is due to "ambiguous paths between tables" This is the warning I'm getting if I try to switch the relationship to active.
If I deactivate one and activate the other one manually, the issue just moves to other relationship and it's other visuals affected.
Need help please
I think you've fixed it. The file is no longer accessible.
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
93 | |
88 | |
70 |
User | Count |
---|---|
166 | |
133 | |
129 | |
102 | |
98 |