On call Calendar

[swaroopjk]

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:

Dates	John	David	Aaron	Jack	Sandy		Name	Phone number	Events
11/21/2020	On Call	Weekend	Weekend	Weekend	Weekend		John	+1 203	On Call
11/22/2020	Weekend	On Call	Weekend	Weekend	Weekend		David	+1 203	Weekend
11/23/2020	Working	Working	On Call	Working	Working		Aaron	+1 203	Working
11/24/2020	Working	Working	Working	On Call	Working		Jack	+1 203	Holiday
11/25/2020	Working	Working	Working	Working	On Call		Sandy	+1 203
11/26/2020	On Call	Holiday	Holiday	Holiday	Holiday
11/27/2020	Holiday	On Call	Holiday	Holiday	Holiday
11/28/2020	Weekend	Weekend	On Call	Weekend	Weekend
11/29/2020	Weekend	Weekend	Weekend	On Call	Weekend
11/30/2020	Working	Working	Working	Working	On Call
12/1/2020	On Call	Working	Working	Working	Working
12/2/2020	Working	On Call	Working	Working	Working
12/3/2020	Working	Working	On Call	Working	Working
12/4/2020	Working	Working	Working	On Call	Working

[v-lili6-msft]

hi  @swaroopjk 

You could try to use custom visual to get it:

Calendar by MAQ Software

Regards,

Lin

[swaroopjk]

Hi Lin,

I tried using the visula but nogo:

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

[v-lili6-msft]

hi  @swaroopjk 

You could click get it now

then download  a sample pbix file to have a try.

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

Regards,

Lin

[swaroopjk]

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

[v-lili6-msft]

hi  @swaroopjk 

Data Fields:

1) Start date and Events are mandatory fields.

you need put a field into Events too.

Regards,

Lin