Constant Values in Waterfall Chart

[Anonymous]

Hello,

I am trying to make a waterfall chart for weekly employee productivity. I am not able to keep the total hours per day as a constant so that we are able to compare on a weekly basis. I also want to keep breaks(1hour) as a constant as well. Anybody knows the solution for this issue?

Thank you

[v-lili6-msft]

hi, @Anonymous 

You may try to add Constant Line for Waterfall Chart.

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

If not your case, please share some simple sample data with the explanation.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[Anonymous]

hi @v-lili6-msft ,

Is it possible to make the constant in such a way that when we choose multiple employees the constants add up?

Thanks.

[v-lili6-msft]

hi, @Anonymous 

Based on my test, I am afraid you could not achieve this feature currently, you could vote for this idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20015260-dynamic-constant-line-for-targets-benchmarks

and here is the same post for you refer to:

https://community.powerbi.com/t5/Service/Dynamic-Target-line-in-Waterfall/td-p/518903

Best Regards,

Lin