cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KhanhTNguyen
Level: Powered On

SUM And filter for barchart

I want to calculate the SUM estimation of work hour, filter by Month and customername based of Gallery to a BarChart

so far, I have this for legends and its working, ( The dropdown with Proper(Calendar.MonthsLong()) )
Distinct(Filter(Gallery4.AllItems, Periode = Dropdown2.Selected.Value), CustomerName)

 

 

BUT for the graph this dosen't work !
Sum(Filter(Gallery4.AllItems, Periode = Dropdown2.Selected.Value), ProjectTime)

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: SUM And filter for barchart

Hi @KhanhTNguyen ,

 

Could you show me the structure of your data source ?

What kind of chart do you use ?

Which property is the formula set to ?

 

I assume that you use Line chart control.

Do you want to show the Sum estimation of work hour in Line Chart ?

 

I have made a test.

I create a sharepoint list named test7. Periode column is single text type . CustomerName column is a single text type. ProjectTime is number type.

9.PNG10.PNG

Set Items property of LineChart1 to :

{Title :"name1",value:Sum(Filter(Gallery1.AllItems,Periode =Dropdown1.Selected.Value),ProjectTime)}

Regards,

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: SUM And filter for barchart

Hi @KhanhTNguyen ,

 

Could you show me the structure of your data source ?

What kind of chart do you use ?

Which property is the formula set to ?

 

I assume that you use Line chart control.

Do you want to show the Sum estimation of work hour in Line Chart ?

 

I have made a test.

I create a sharepoint list named test7. Periode column is single text type . CustomerName column is a single text type. ProjectTime is number type.

9.PNG10.PNG

Set Items property of LineChart1 to :

{Title :"name1",value:Sum(Filter(Gallery1.AllItems,Periode =Dropdown1.Selected.Value),ProjectTime)}

Regards,

Eason

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

KhanhTNguyen
Level: Powered On

Re: SUM And filter for barchart

Hey Eason thanks you for helping me out, but my concern lie in the customername field in gallery due to fact that a customer"customername" can have more than 1 project.

 

I need to sum up the projectime based on periode and customername,

 

Best regard, 

Khanh

KhanhTNguyen
Level: Powered On

Re: SUM And filter for barchart

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 197 members 4,388 guests
Please welcome our newest community members: