Want datatype as text for date column

[Anonymous]

Hi,

i have the following table.

Date                   Count

31Jan2019           2

01Jan2019           1

22Jan2019           5

want to create following widget. how can i acheive.

[PattemManohar · Accepted solution]

@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"