Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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.
hi, @Anonymous
Based on my test, I am afraid you could not achieve this feature currently, you could vote for this idea:
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