topic Re: Calendar Visual in Custom Visuals Development Discussion

Calendar Visual

SabineOussi — Tue, 16 May 2017 10:11:13 GMT

Hello everyone,

I am using the calendar visual to display a simple date and count.

Problem is it's displaying nothing for the dates between March 28 and the end of the year though there is data for all years.

Is anyone else having this issue?

Any solutions?

Thanks.

[EDIT] This is also the case of the visual's sample file.

Re: Calendar Visual

v-viig — Thu, 18 May 2017 09:36:23 GMT

Hello @SabineOussi,

I'm not able to reproduce the same issue using my own data-set (please take a look at the screenshot below).

Is it possible to share a data-set that you used to reproduce the issue?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Calendar Visual

SabineOussi — Thu, 18 May 2017 09:48:24 GMT

Hi @v-viig

Here is the dummy dataset I used.

As I said, the same issue is happening with the visual's sample report.

I am using the latest PBI Desktop Version: 2.46.4732.461 64-bit (May 2017)

Thanks.

Re: Calendar Visual

v-viig — Fri, 19 May 2017 14:32:29 GMT

@SabineOussi

I'm not able to reproduce the issue using your data-set (please take a look at the screenshot below).

Do you have any filter on your report page?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Calendar Visual

SabineOussi — Mon, 22 May 2017 04:58:07 GMT

Not at all.

I tried it on a colleague's pc and it also doesn't work.

What PBI version, Windows edition, and processor are you using?

Thanks.

Re: Calendar Visual

RudyK — Mon, 22 May 2017 14:40:12 GMT

I'm encountering the same issue at the moment. I don't see any data from June, but when I select Export data from the Calendar visual, it shows me the data:

2017-06-12 09:00:00,5
2017-06-13 09:00:00,3
2017-06-14 09:00:00,2
2017-06-15 09:00:00,1
2017-06-16 09:00:00,1
2017-06-19 09:00:00,1
2017-06-20 09:00:00,3
2017-06-22 09:00:00,1
2017-06-28 09:00:00,1
2017-07-03 09:00:00,1

I have no Page or Report filters applied.

Re: Calendar Visual

v-viig — Mon, 22 May 2017 16:20:49 GMT

How many data rows does your data-set have? Custom visual doesn't suppor more than 1000 rows by default.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Calendar Visual

RudyK — Tue, 23 May 2017 10:43:02 GMT

I discovered what the problem is. Only the records are shown where the DateTime field has a time value of 00:00:00:

Record with a time which is different (like in de the screenshot: 09:00:00 and 13:00:00) are not shown.

Re: Calendar Visual

andycross — Tue, 23 May 2017 11:02:12 GMT

Could you tell me which Locale you work in?

I have loaded the same data locally and see a fully rendered visual.

Andy

Re: Calendar Visual

RudyK — Tue, 23 May 2017 11:25:52 GMT

Dutch (Nederlands). I'm loading data from a SQL table by the way.

Re: Calendar Visual

v-viig — Tue, 23 May 2017 11:59:15 GMT

@andycross,

I suppose that you should include an ability to show dates with time to Calendar visual.

Could you please consider this in future versions of the visual?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Calendar Visual

SabineOussi — Tue, 23 May 2017 12:03:51 GMT

@v-viig @RudyK I don't think that's the problem.

The visual sample file also has the same behavior and the time for all dates is 12:00:00 AM

Re: Calendar Visual

v-viig — Wed, 24 May 2017 12:52:32 GMT

@SabineOussi,

I'm not able to reproduce the same issue using your locale.

Could you please change data type format to date (instead of Date/Time) using Power BI Desktop's top ribbon?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Calendar Visual

SabineOussi — Wed, 24 May 2017 12:56:51 GMT

Hi @v-viig

It is already of type date and not date/time.

Re: Calendar Visual

v-viig — Wed, 24 May 2017 13:00:56 GMT

@SabineOussi,

Could you please clarify these items:

Which version of Power BI Desktop do you use?
Can you reproduce the same issue in Power BI service?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Calendar Visual

SabineOussi — Wed, 24 May 2017 13:11:16 GMT

I am using the latest PBI Desktop version

Same issue on the server when I import the calendar visual and when I publish an already created report, the screenshot below is the sample downloaded from the calendar visual page