Want datatype as text for date column

Anonymous  Hope I've understood your requirement corrrectly...

 

Please create a new table as below - which will generate a calendar table with date field single column with min and max dates as boundaries from your source table. (In this example, it will be 01stJan2019 till 31stJan2019)

 

Test217DateGen = CALENDAR(MIN(Test217DateConv[Date]),MAX(Test217DateConv[Date]))

Then create a relationship between this Date table and your source table using "Date" field.

 

Create a New Measure as below

 

Test217Count = CALCULATE(SUM(Test217DateConv[Count]))+0

Then create your graph, using Date field from newly generated date table and count from source table. Also, change the "Type" of your x-axis to "Categorical"