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,
I am currently using a calendar table for my model and am experiencing null values for my report after configuring the calendar table.
I have completed the following steps:
1. Adding the calendar table to the model
2. Relationship between calendar table and entity table
3. Marking calendar table as the calendar table
Background context
Relationship
Calendar.Date -> Invoice.Date (1M)
Report
Visualization settings:
Axis = Calendar.FiscalYear
//My calendar table
Legend = Null
Values = Sales
Thanks!
Solved! Go to Solution.
@wetherington , Seems like Invoice table Date has a timestamp
Check by changing the data type to datetime and having a format that can display time, if so create a new column
date only = Invoice[Date].date and join this with the calendar.
Also, check your calendar has all dates in the invoice table
@wetherington , Seems like Invoice table Date has a timestamp
Check by changing the data type to datetime and having a format that can display time, if so create a new column
date only = Invoice[Date].date and join this with the calendar.
Also, check your calendar has all dates in the invoice table
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |