Making a worktime overview for the employees of a store

[Laurens_wolf]

Hey all!

we are trying to make a week overview of our stores how much people work there,
something like this:

so we have line data like this
employee,             store,                 dateTimestart,             datetimeEnd
Laurens Wolf,     Amsterdam,    26/09/2022 08:00:00,     26/09/2022 17:00:00
Laurens Wolf,     Amsterdam,    27/09/2022 08:00:00,     27/09/2022 17:00:00
Laurens Wolf,     Amsterdam,    28/09/2022 08:00:00,     28/09/2022 17:00:00

how can i take that and make a weekchart that drwas a line when someone is working?(and in adition color the line if they are not working due they are sick)

thanks in advance!

sincerely,
Laurens Wolf

[v-xiaotang]

Hi @Laurens_wolf 

Thanks for reaching out to us.

>> how can i take that and make a weekchart that drwas a line when someone is working?(and in adition color the line if they are not working due they are sick)

My suggestion is you can use conditional formatting in table or matrix visual, FYI: 

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.