Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Community. I'm having some troubles with my date in the X axis.
I have a table looking like this:
I'm trying to count the amount of workers filtered by date, like this:
But as youcan see, there is plenty of data that appears as a Blank date. I have created a Date table and have linked it to my data table, like this. The link appears as dotted, don't really know why.
I would really appreciate help on this matter. I've been struggling with for a couple of hours. If there's a way I can send the file so you can see it, I would be happy to send it to you. I have checked the format of the date column and it is a formated as a date column. I don't really know what else I can do
Thanks in advance.
Solved! Go to Solution.
The dotted line means that the link between the table is not presently active. If you double click on that line you will get the link properties. There is a tick box called "Make this relationship active".
If you are getting blanks in your table, this usually means that certain dates are not being related in to your date axis (usually your date table). Common reasons for this are things like your data source being in a DATETIME format or your date table does not have enough dates to cover all of the dates in your source.
The dotted line means that the link between the table is not presently active. If you double click on that line you will get the link properties. There is a tick box called "Make this relationship active".
If you are getting blanks in your table, this usually means that certain dates are not being related in to your date axis (usually your date table). Common reasons for this are things like your data source being in a DATETIME format or your date table does not have enough dates to cover all of the dates in your source.
@Anonymous thanks fo your help.
I tried cicking on "Make this relationship active" but the following message appeared:
"There are ambiguous paths between 'Date table' and 'Source data Table' and 'Another table linked to 'Source data Table'.
So I deleted the relationship between my source that and that other table. When I did that, everthing worked fine! Thanks again
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |