Filter a graph which displays a sum amount between two dates

[Anonymous]

Hi everybody,

I have an total of hours that are spread between two dates, e.g :

Service	Activity	Start date	End date	Time spend (hours)
A	Read	01/01/2020	31/12/2020	1
B	Write	15/01/2020	15/06/2020	3
A	Write	01/06/2020	31/12/2020	4

First, I wanted a graph, showing the repartition of the hours over the year.

I managed at creating a date table, and for each date I calculated the total of hours spent, following this procedure.

That gave me a graph, with date on the X-axis, and the number of hours on the Y-axis.

I can easily manipulate my X-avis with a time slicer, that allow me to focus on a precise period of time.

The point is : I cannot filter my graph by Service or by Activity.

How could I manage to do that?

Marvin

[v-easonf-msft]

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark your reply as Answered to close this thread?

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi , @Anonymous 

According to your description , I’m a little confused with the ”date” your mentioned. Sample data and expected output would help tremendously.

Here is a sample I made. Hope it can help you a little bit:

Best Regards,
Community Support Team _ Eason