Calendar visual not displaying correctly in the service

[DrewGoode]

Hi,

I am using the calendar visual by MAQ software and have done some work (in Power Query) using other pages on the community site to bring in recurring outlook events and eliminate duplicates etc. Everything looks good in the desktop (below):

But when I publish to the service it changes the time on the recurring events and adds them all back in (e.g. in the picture above from the desktop Busy 14:00 - 15:00 on 7th Jan is a recurring monthly event that becomes Busy 13:00 - 14:00 listed every week in the service):

Has anyone experienced anything similar and know how to solve it? I've been playing around with the code for a while now but it seems to be something when it goes into the service and the way it retrieves the data from the outlook exchange?

Thanks,

Andrew

[DrewGoode]

Hi,

I was able to use a workaround for this using Power Query and DAX. A fairly specific solution to me referencing the meeting names behind the scenes that were causing problems but a couple of pointers:

• I don't know why the meeing times were being adjusted back an hour for recurring events but I added columns in Power Query to add an hour to the time, based on if the appointment type was a recurring event. I then added an additional conditional column to pull thorugh the start and end time based on if it was recurring or not
• Using DAX, i created a formula to check for monthly recurring appointments and if it was recurring and had a start date of less than or equal to 7 days (given that it was scheduled to be in the first week of each month) assign it the value 'keep' otherwise 'exclude'. I then applied a report level filter to only include those labelled as 'keep' even though no exclue values existed in my desktop data

All a bit confusing and still not sure why it all went pear shaped in the service but these patches have worked for me.....for now.

Andrew

[Anonymous]

HI @DrewGoode,

It seems like you are working with third party custom visuals.
For compatibility issues between custom visual and power bi service, I'd like to suggest your contact with visual author to report and fix this issue. (you can find it in office store -> power bi custom visual -> calendar visual -> support option)

Regards,

Xiaoxin Sheng