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 currently have a dataset [date,type,quantity] I'm loading it into a line chart.
Date are in "date" format, but I have some "jumps" on the dataset (using some types) as in:
05/01 - 05/02 - 05/05 - 05/07
I need that the empty records (missing dates) appear in the X-axis of the graph, how would you do it? each type have their own empty records.
Thank you!
Solved! Go to Solution.
Add relationship to the calendar table.
Drag date from a calendar table and add an appropriate measure.
Table = CALENDAR ( MIN ( Table1[date] ), MAX ( Table1[date] ) )
Measure = SUM ( Table1[quantity] ) + 0
Hi! I had a calendar table, still not sure how to use it to fill empty dates on my data table1[value,date].
Thank you!
Add relationship to the calendar 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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |