cancel
Showing results for 
Search instead for 
Did you mean: 

On call Calendar

I am trying to create an oncall calendar in power BI and display it in the regular calendar format. Any ideas on how do i go about it?

 

Below is the snippet of the raw data:

 

DatesJohnDavidAaronJackSandy NamePhone numberEvents
11/21/2020On CallWeekendWeekendWeekendWeekend John+1 203On Call
11/22/2020WeekendOn CallWeekendWeekendWeekend David+1 203Weekend
11/23/2020WorkingWorkingOn CallWorkingWorking Aaron+1 203Working
11/24/2020WorkingWorkingWorkingOn CallWorking Jack+1 203Holiday
11/25/2020WorkingWorkingWorkingWorkingOn Call Sandy+1 203 
11/26/2020On CallHolidayHolidayHolidayHoliday    
11/27/2020HolidayOn CallHolidayHolidayHoliday    
11/28/2020WeekendWeekendOn CallWeekendWeekend    
11/29/2020WeekendWeekendWeekendOn CallWeekend    
11/30/2020WorkingWorkingWorkingWorkingOn Call    
12/1/2020On CallWorkingWorkingWorkingWorking    
12/2/2020WorkingOn CallWorkingWorkingWorking    
12/3/2020WorkingWorkingOn CallWorkingWorking    
12/4/2020WorkingWorkingWorkingOn CallWorking    

 

Status: New
Comments
Community Support

hi  @swaroopjk 

You could try to use custom visual to get it:

Calendar by MAQ Software

 

Regards,

Lin

New Member

Hi Lin,

 

I tried using the visula but nogo:

 

swaroopjk_1-1603273114272.png

 AM i missing something? Do you have document on using this visual?

 

Community Support

hi  @swaroopjk 

You could click get it now

 

4.JPG

 

then download  a sample pbix file to have a try.

5.JPG

 

and there is the document in this sample pbix file too.

 

Regards,

Lin

New Member

I have downloaded the visual but when i enter the details on the filters it does not populate in the visual, se below:

 

swaroopjk_0-1603278350181.png

 

Community Support

hi  @swaroopjk 

Data Fields:

1) Start date and Events are mandatory fields.

 

you need put a field into Events too.

 

Regards,

Lin