Constant line that adaps to the number of day´s selected

[wolfy_]

Hi, it is possible to add a constant line that adapts to the number of days selected?

Every person should do at least 480 minutes in the sum of the different projects that they work.

So if I select 3 day I would like the constant line be 480*3 days, 1440 minutes.

If I select 5 day it should be 2440.

 

Is this possible to implement?

[v-yulgu-msft]

Hi @wolfy_,

Please create measures similar to:

Selected day =
DATEDIFF ( MIN ( 'Data table'[Date] ), MAX ( 'Data table'[Date] ), DAY ) + 1

constant line = [Selected day]*480

By the way, it is not able to add a dynamic value like a measure for constant line. You could insert a Line and Stacked column chart, then, add above measure [constant line] to "Line values" section.

Best regards,

Yuliana Gu

[wolfy_]

Hi, it works partially.

I think is is not working properly because we work 24x7 and some workers have day off diferent from others.

Nevertheless, it is possible to put the constant line independent of the worker?

[v-yulgu-msft]

Hi @wolfy_,

What do you mean "we work 24x7 and some workers have day off diferent from others."?

" it is possible to put the constant line independent of the worker?"

Please try this:

Selected day =
DATEDIFF ( MIN ( 'Data table'[Date] ), MAX ( 'Data table'[Date] ), DAY ) + 1

constant line = CALCULATE([Selected day]*480,ALL('Data table'))

Regards,

Yuliana Gu