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?
[EDIT] This is also the case of the visual's sample file.
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.
How many data rows does your data-set have? Custom visual doesn't suppor more than 1000 rows by default.
Microsoft Power BI Custom Visuals
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.
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
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.
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.
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?
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!
Click here to read more about the May 2022 updates!