Calendar Event visual for Power BI is changing end date to 1 day earlier
Hello
I need urgent assistance please! I created a calendar in power BI using the MAQ Calendar visual. The calendar visual shortened the event 1 day in all cases. How can I avoid that and make sure that the end date is correct? These events are supposed to include the end date but it is cutting one day short. I don't need exact time frames. I just need to show them as an all day event. If this is not fixed, the calendar visual is useless since it shows incorrect information.
-
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.
- 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
-Krishna from MAQ Software
0 -
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 having 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,
0 -
Hi,
I found a fix that works in one step. In Power BI Desktop, go to the Data view and click Transform Data. In the new window, select your End Date column to highlight all rows. Click on the Transform tab in the Ribbon and in the Date & Time Column group, click the drop-down arrow under the Time icon. Select the Hour option to open a sub-menu. In the sub-menu, select End of Hour to set the end time to 1:00:00 AM.
0
Please sign in to leave a comment.
Comments
3 comments