Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
rginny_
Helper I
Helper I

Multi-day events not showing in calendar visual

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?

 

tech roadmap.png

1 ACCEPTED SOLUTION
rginny_
Helper I
Helper I

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!

View solution in original post

6 REPLIES 6
MAQSupport
Solution Supplier
Solution Supplier

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.

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

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

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

khairi_0-1692776886845.png

khairi_1-1692776904993.png

it should end at 16 not 15

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_
Helper I
Helper I

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!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.