Bci calendar not giving multiple date count

[Anonymous]

Hi Team,

I have started using a calendar format "Bci Calendar" and am not thouroughly understanding this . Please see the below issue and provide me a help to resolve the issue. 

My Date field for this calendar is "Reported Date " and Measure Data is "Count of Incidents" as shown in screenshots. The highlighted ones in Blue color in calendar are the count for each day which should be 3 for 1st March, 1 for March 2nd ,2 for March3rd and 1 for March 4th . However, if you check its showing count as 1 for all 4 days . I am not doing distinct count as well . 

But still receiving wrong count. Please check and let me know what shall i do in this case.

[Anonymous]

the data in my calendar is on top of each other instead of adding it up. 

what i want to show is the total number of workorder we have on each day. 

Please help!

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

I would suggest you add a Date column.Then use the column in the calendar.For further,please check the page1 and Hints in the sample report.Here is the article.

Column = DATEVALUE(Table1[Date])

Regards,

Cherie

[Anonymous]

Thanks a lot for the Quick help  ! It worked Perfectly .