web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps GroupBy multiple colum...

Power Apps

Answered

GroupBy multiple columns in the Chart

(0) Share

Report

Report

Posted on by ernu

140

Hello,

I have two columns in the sp list as below.

Month	Total Cost
Jun	150
Jun	100
Mar	50
Oct	60
Nov	80
Nov	120
Nov	130
Apr	40
May	30

When I try to visualize this table in the ColumnChart, it shows each month separately.

I need to show, "Total Cost" data by grouping these months. I write a code but it didn't work.

AddColumns(
 GroupBy('MyDataSource', "Month", "GroupData"),
 "Total Cost",
 Sum(GroupData, "Total Cost")
)

How can I do this grouping?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ernu ,

You should replace the " with '.

Please try:

AddColumns(
GroupBy('MyDataSource', "Month", "GroupData"),
"Total Cost",
Sum(GroupData, 'Total Cost')
)

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation