Show Month wise records in column chart in canvas app

(1) Share

Report

Posted on by Powerappsuser14

Hi Team,

I have requirement to show the month and year on X-axis of column chart and created record count on Y-axis in canvas app.

Dataverse table contains account table. It contains account name, account create date.

Dataverse Data is

Account Name	Created Date
Acme Inc.	2023-01-10
GlobalTech	2023-01-25
Innovators	2023-02-15
StarTech	2023-02-20
FutureWorks	2023-03-05

Added to canvas app . My requirement is show the month wise created records in column chart.

Added X-Axis = Month name, Y-Axis =Created Records Count.

Using Below code in chart items property but getting error.

AddColumns(GroupBy(AddColumns('Account Head',"MonthName",
       Text(Month(['Created Date])',"[$-en-US]mmmm")),
       "MonthName","MonthlyRecords"
    ),
        "RecordCount",CountRows(MonthlyRecords)
)

but getting errors provide correct solution to my requirement.

Thanks in advance for quick response.

All responses (1)

Answers (0)

WarrenBelz 141,122 on at

Like (0)

Report
Show Month wise records in column chart in canvas app

Hi Powerappsuser14

You do not need quotes "" around either AddColumns or GroupBy parameters. You also do not need Month in the Text format as you are already stiplating this.
AddColumns( GroupBy( AddColumns( 'Account Head', MonthName, Text('Created Date',"mmmm") ), MonthName, MonthlyRecords ), RecordCount, CountRows(MonthlyRecords) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee