Power Apps Custom Chart 07-29-2020 07:47 AM

[DeepakS]

Hello All,

Try out my new custom "BarChart" and "ColumnChart" component for Power apps.

Key Features:

• Fully configurable and extendable BAR chart
• Drill-down or on screen filtering
• Responsive

Configurable Properties:

• Chart Data: Input property for chart data source
• ChartGropedData : Input property that will allow the user to select group by and total column

  Two option to display Data
  /* Update following Columns name based on the data
  Category : Column name that you need to group by
  DataValue: Column name that hold the value to display
  /*Option 1*/
  /* Use following to group and sum the data */

  SortByColumns(
  AddColumns(
  GroupBy(
  DColumnChart.ChartData,
  "Category",
  "MyGroup"
  ),
  "Total",
  Sum(
  MyGroup.DataValue,
  DataValue
  )
  ),
  "Total"
  )

  /*Option2*/

  /* Use following to group and count the data */

  /******************************************
  SortByColumns(
  AddColumns(
  GroupBy(
  DColumnChart.ChartData,
  "Category",
  "MyGroup"
  ),
  "Total",
  CountRows(MyGroup)
  ),
  "Total"
  )
  ******************************************/

• DataRange : Input property to define data range for the chart
• DataColor(1 to 😎: Input property to define a custom color for Bar or column.
• ShowAxis : Input Property to show/hide the axis
• DataPointPrefix : Input Property to add a prefix to the data-points
• ChartBehaviour: Input property. Select 1 for On Screen filter and Select 2 to enable drill-down
• DrillDownScreenName : Optional Input property. User should set it the screen that chart should drill-down to
• ChartSelectedItem: Output property and provide currently selected bar/column item details 

Let me know your feedback and if you have any questions?

Connect with me on:

Twitter: @deepak_s22  

Linkedin: Deepak 

Regards,

Deepak S

[Thrasymaque]

Hello & thanks a million for this components it would be sper helpfull

I am actually strugulling to use it 

I would like to show data that has been selected in a previous page 

so to show my data (out of your graph I am doing the following : 

1 - Creating 9 formviewer

Datasource : MonthlyProgress

Item : BrowseGallery12.selected

2- then I do have a datacard in each form 

Budget_x0020_Software_x0020_Total

I am having 9Forms & 9 datacard like that (others are : Budget_x0020_Hardware_x0020_Total etc etc ...)

instead of showing figures I d like to show one bar with the amount currently appearing in each Datacard 

Is there a way to deal with that in your proposal ?

many thnx

br

Fred

[Anonymous]

I am getting an error while trying to import this chart

[SherryEyre21]

Hi, I have the same problem. Have you found any way to work out?