cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aadilganie
Level 8

Group and Filter Chart Data

Hi,

 

I am trying to show users a chart breakdown of their expenses by item type & total (sum) and filtered by their BudgetID.

I have managed to get the item type grouped but the chart now shows the series and lables as item type. How do I add the filter by budget ID and the total to the chart?

 

This is what I have so far:

GroupBy('Budget Management Details',"Item_x0020_Type_x0020_Text", "Item Type")

 

I know I may have to use the AddColumns function but keep getting the syntax incorrect.

 

Please assist!

1 ACCEPTED SOLUTION

Accepted Solutions
aadilganie
Level 8

Re: Group and Filter Chart Data

I think I have managed to figure it out with the following:

 

AddColumns(GroupBy(Filter('Budget Management Details',Budget_x0020_ID_x0020_Text = varLastID),"Item_x0020_Type_x0020_Text","Budget_x0020_ID_x0020_Text","ItemGroup"),"varTotal",Sum(ItemGroup,Total)),Budget_x0020_ID_x0020_Text)

 

Have had to add lookup columns as Text columns in the child list as could not read lookup columns in the group by. Not sure if there is a way aroun this...

View solution in original post

1 REPLY 1
aadilganie
Level 8

Re: Group and Filter Chart Data

I think I have managed to figure it out with the following:

 

AddColumns(GroupBy(Filter('Budget Management Details',Budget_x0020_ID_x0020_Text = varLastID),"Item_x0020_Type_x0020_Text","Budget_x0020_ID_x0020_Text","ItemGroup"),"varTotal",Sum(ItemGroup,Total)),Budget_x0020_ID_x0020_Text)

 

Have had to add lookup columns as Text columns in the child list as could not read lookup columns in the group by. Not sure if there is a way aroun this...

View solution in original post

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: 307 members 3,521 guests
Please welcome our newest community members: