Multi-day events not showing in calendar visual

[rginny_]

I'm using the Calendar Visual by MAQ software and I'm struggling to get it work properly. For some reason, all events show up only on their start date, even if they are mutiple days long and their start and end dates are different. 

See below the example. The Tech Roadmap workshop runs from 2 to 3 June but only shows up on the 2nd. Could someone help me why this is happening?

[MAQSupport]

Hello,

Thanks for reaching out.

For formatting start and end date, you need to consider the following as these are unfortunately the limitation of the API used to render the Calendar visual:

1. When only date (not date time) is provided as End date to the visual, it takes the end time for the event as 12:00 am and hence, the event ends on the previous day. For example, when date is 29/1/2019, by default it takes 29/01/2019 12:00 AM as its end date time.
2. If an event lasts for more than a day and the start and end times are before 9 AM, then the end date of the event in the visual will be a day before the end date given in the data. Tooltip will represent the date and time as per the data passed.

Let us know if it meet your requirements and revert back in case of any further issues.

[khairi]

Hello how can we solve  this problem of calendar end date?

[copycat003]

Hi Khairi,

If you only enter the date for the end of an event, the visual will assume that the event ends at 12:00 AM on that day. This means that if the event ends on August 29, 2023, and you only enter the date, the visual will show the event as ending on August 28, 2023.

If an event lasts for more than one day and the start and end times are both before 9 AM, the visual will show the end date of the event as one day before the actual end date.

For example, if an event starts on August 28, 2023 at 8 AM and ends on August 29, 2019 at 8 AM, and you only enter the date for the end of the event, the visual will show the end date as August 28, 2023.

To avoid this, you can enter the time for the end of the event as well as the date. This will ensure that the visual shows the correct end date of the event.

For more information you can visit this link: FAQs for Calendar Power BI Custom Visual – MAQ Software (zendesk.com)

Thank you.

-

MAQ Software

[khairi]

Hello thank you for you answer , i tried to put in the end date datetime but it didnt fix my problem ,

it should end at 16 not 15

[MAQSupport]

Hi Khairi,

Please share a sample report to us at support@maqsoftware.com

We will analyze the issue and get back to you at the earliest.

Thank you.

-

MAQ Software

[rginny_ · Accepted solution]

Ignore me - I have actually figured it out. 

For some reason the end date needs to be one day after the one that you want to visualise. 

So by setting the end dat to the 4th of June for the Workshop, it shows up as a two day event on the 2nd and 3rd.

Weird but it works!