Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
179 | |
86 | |
69 | |
63 | |
55 |