cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SabineOussi
Skilled Sharer
Skilled Sharer

Calendar Visual

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.

Capture.PNG

 

Is anyone else having this issue?

Any solutions?

 

Thanks.

 

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

27 REPLIES 27
RudyK
Regular Visitor

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.

v-viig
Community Champion
Community Champion

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

RudyK
Regular Visitor

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

 

m6lPdeU

 

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

Hi

 

Could you tell me which Locale you work in? 

 

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

 

Andy

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

v-viig
Community Champion
Community Champion

@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

@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

v-viig
Community Champion
Community Champion

@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

Hi @v-viig

 

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

v-viig
Community Champion
Community Champion

@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

I am using the latest PBI Desktop version

PBI.PNG

 

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

PBI Service.PNG

v-viig
Community Champion
Community Champion

@SabineOussi,

 

Are you able to reproduce the same issue on any another machine?

 

I suppose that the issue is related to locale and timezone, but we have to be sure.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

@v-viig

 

I'm currently using Windows 10 Enterprise.

Same issue on Windows 10 Pro (different IP) and Windows 8.1 (same IP).

 

All running 64-bit OS.

v-viig
Community Champion
Community Champion

@SabineOussi,

 

Do you use Dutch (Nederlands) for all machines?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

@RudyK is using Dutch (Netherlands).

I use English (United States) and yes for all machines.

v-viig
Community Champion
Community Champion

@SabineOussi,

 

Which timezone do you use on your machine?

 

Is it possible to arrange a remote session with you if there're no repro steps on my machine even with your timezone and locale?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

RudyK
Regular Visitor

Hi All,

 

I made an extra column where I concat the DATE part and a fixed 00:00:00 time. Now (as I assumed earlier in this thread) works like a charm!

 

So there is definitly an issue with datetimes with another time than 00:00:00.

v-viig
Community Champion
Community Champion

@RudyK Thanks for your investigation.

 

@SabineOussi Can you try @RudyK's solution on your machine?

 

Let's arrange a meeting if this solution doesn't work for you.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Unfortunately this doesn't work.

I have managed to find and correct the bug with non-midnight DateTimes being used. I'll package a new version soon.

 

@SabineOussiI think this is culture related, what is your local time zone and regional settings?

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors