@kit1128
To do this you would need to create a collection. Put this code in the OnVisible property of your screen.
ClearCollect(
myProjects,
DropColumns(
AddColumns(
GroupBy(Filter(ETimeSheetMain, Title = UserMail),"Project","GroupedProjects"),
"Sum of Value",Sum(GroupedProjects,WorkingHours)
),
"GroupedProjects"
)
)
Replace the code in the Items property of Gallery1 with this.
myProjects
Finally, use this code in the Width property of your bar.
(ThisItem.'Sum of Values'/Max(myProjects,'Sum of Value'))*Gallery1.Width
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
