Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

MAQ Software Calendar Bug?

MAQSupport  I am using the Caendar visual to display downtime in our plant and this may be a possible bug, or perhaps a formatting issue I may be missing.   In the attached image it shows that the ...
MAQSupport's avatar
MAQSupport
Solution Supplier
3 years ago

Hello,

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.

  • 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.
  • 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.

As a workaround to display the most recent date, add the date and time format in dataset. For example, for start date 07-06-2021 00:00:00 and end date 09-06-2021 00:00:01, it will display correctly.

 

 

Let us know if it meets your requirements and revert in case of any further issues

Thanks

Bfreire's avatar
Bfreire
Microsoft Employee
3 years ago

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,

  • Stwiz1313's avatar
    Stwiz1313
    New Member
    1 year ago

    I've solved this in the power query by:

    1) Changing Type From Date --> to Date/Time --> to Text.

    2) Replaced 00:00:00 to 00:10:00 

    3) Changed Type back to Date/Time. 

    Worked for me.