Forum Discussion
Anonymous
1 year agoNot applicable
Display missing day also in line chart
Hi Experts, i have the req where i need to missing day column data also as we don't have day in for 21st and 23rd however we need to show 21st and 23rd in line chart ..is it possible ? ...
Fowmy
Super User
1 year agoAnonymous
Create a dedicated Date Table in your data model and establish a one-to-many relationship between the Date Table and your Fact Table using the date column. When visualizing data, use the date column from the Date Table on the X-axis. To ensure that all dates are displayed, even those with no corresponding data, right-click on the axis and enable "Show items with no data."
here a the code create a ates table, modify as needed.
Calendar =
ADDCOLUMNS(
CALENDAR(date(2024,1,1),date(2025,12,31))
,"Day Name",FORMAT([Date],"DDDD")
,"Day of Week",(WEEKDAY([Date],1))
,"Day of Month",DAY([Date])
,"Week",DATE(YEAR([Date]),MONTH([Date]),DAY([Date]))-(WEEKDAY([Date],1)-1)
,"Week Name", "Week of " & DATE(YEAR([Date]),MONTH([Date]),DAY([Date]))-(WEEKDAY([Date],1)-1)
,"Week of Year", WEEKNUM([Date],1)
,"Month", DATE(YEAR([Date]),MONTH([Date]),1)
,"Month Name", FORMAT([Date],"MMMM")
,"Month of Year", MONTH([Date])
,"Month Year Name", FORMAT([Date],"MMM") & " " & YEAR([Date])
,"Month Year Name Sort",(100*YEAR([Date])+MONTH([Date]))
,"Quarter",DATE(YEAR([Date]),SWITCH(ROUNDUP(DIVIDE(MONTH([Date]),3,1),0),1,1,2,4,3,7,4,10),1)
,"Quarter Name", "Q" & ROUNDUP(MONTH([Date])/3,0)
,"Quarter Year Name", "Q" & ROUNDUP(MONTH([Date])/3,0) & " " & YEAR([Date])
,"Year", DATE(YEAR([Date]),1,1)
,"Year #",YEAR([Date])
)