How to fill the date gaps in Power Bi ??

[Anonymous]

The data does not have all the dates, I want to see blanks where there is no corresponding record. In the below diagram i have given monthly filter and its only showing the data for first 9 days as avaialble how can i show the rest of the dates will no data .

[TheMindGymnast · Accepted solution]

Create a seperate dates table using dax 

e.g.
DATE =

ADDCOLUMNS (

CALENDAR (DATE(2001,1,1),DATE(2022,1,1)),

"DateAsInteger", FORMAT ( [Date], "DDMMYYYY" ),

"Year", YEAR ( [Date] )

)

Link this to the sales data and then change the settings on the table : visualizations/values to "show items wth no data"