MAQ Software Calendar Bug?

Hello: Thanks for your response. As per your suggestion, I changed the format to date and time in the “transform data” section of power BI and it seems to work and use the correct end date.  However, I had to manually changed the time to 00:00:01 one by one to each event on each end date cell, because it didn’t allow me to replace 12:00:00 with 12:00:01 in the entire column in just one step. I have more than 100 events in 1 year. This means, I would have to manually enter more than 100 corrections.  Also, my Power BI Events calendar comes from an online excel spreadsheet source that is dynamic and keep changing or adding new events. If I have to make changes manually every time, we add a new event or change a date, it makes this visual very unfriendly and inefficient.

Could you please confirm the following?:

• Is there any way to replace the end date time from 12:00:00 with 12:00:01 in one step?  I couldn’t do it.
• Also, will it help to add a time column for start and end to my spreadhseet original source?
• Instead of users working around this glitch, why can’t MAQ Software fix it in the visual calendar and make it friendlier for users? I have read many people have the same issue. It doesn’t make sense for the visual to assume that the end date should not be included as part of an event. 

Thanks for your help.

Regards,