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.
Go to Solution.
Add relationship to the calendar table.
View solution in original post
Drag date from a calendar table and add an appropriate measure.
CALENDAR ( MIN ( Table1[date] ), MAX ( Table1[date] ) )
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].
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!