How to set the bar width let them scale to fit the gallery

(0) Share

Report

Posted on by kit1128

109

Hi guys,

I create some bar in gallery which length is depending on 'sum of value'. My gallery width value is 640. So it will exceed the gallery width. I want all of the other bar sizes to be a ratio of that maximum size, based on 'sum of value'.

未命名3.png

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

kit1128 109 on at

Like (0)

Report

Need Help~~

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (2)

Report
@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."

Was this reply helpful? Yes No
kit1128 109 on at

Like (0)

Report

@mdevaney ,
OMG, thank you so so so much!! You helped me a lot, you're awesome dude.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

@kit1128

It was an interesting problem. I'm glad I could help 🙂

Was this reply helpful? Yes No