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.
Hi all,
I have a table wich contains all the engagements and associated Create Date. I want to create visuals that show engagements grouped by FiscalYear. To do that I created another table having columns Date and its associated FiscalYear. A relationship was created between the 2.
However, when I go to my visuals, all the engagements are getting a FiscalYear value as blank.
Can you pls help me?
Solved! Go to Solution.
Yes did. I got a solution for it. It was a problem of not matching data type. But I had to create a calculated column having data type as "Date" from the original "Data/Time" column, for some reason I was getting an error in all rows just chaging the data type in the original column, so this extra column was needed. After creating this new column I updated the relantioship between the two and it works now. Thanks much.
@gabilamarcks Check the datatypes in both the "Edit Queries" section as well as the model. Make sure they match. If that doesn't work, does the date value exist in both tables?
Thank you for this a year and some months later! I had the data type correct in the model but not the query.
Indeed the data types were different when I went to "Edit Queries". I adjusted both for Date/Time in the queries and the models. Still doesnt work. I am sure there are matching data values in both tables.
@gabilamarcks did you "Close and Apply" the change?
Yes did. I got a solution for it. It was a problem of not matching data type. But I had to create a calculated column having data type as "Date" from the original "Data/Time" column, for some reason I was getting an error in all rows just chaging the data type in the original column, so this extra column was needed. After creating this new column I updated the relantioship between the two and it works now. Thanks much.
If you double click on the relationship line what does it look like?
That will help in getting a better understanding of the issue.
There we go
Almost certainly the problem is your CreatedDate also has a time. Even if not "displayed" that way. You need to strip those off.
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 |
---|---|
114 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |