Column chart controls in Power Apps

The Column chart controls show data as graphs with x- and y-axes. Column chart is a grouped control. The group contains three controls: a Label for the title, the chart graphic, and a Legend. The Column Chart control is a great way to visualize data in a simple and easy-to-understand format. You can use it to display data trends, comparisons, and distributions in your app.

The column chart has the following properties: 1. Items The Items property specifies the source of data that appears in a control such as a gallery, a list, or a chart. 2. NumberOfSeries The NumberOfSeries specifies how many columns of data are reflected in a column chart. 3. ItemsGap The ItemsGap specifies the distance between columns in a column chart. 4. Markers The Markers property specifies whether the data points are visible on each data point. By default, its value is true. 5. MarkerSuffix The MarkerSuffix property specifies the text that appears after each value in a column chart for which the Markers property is set to true. 6. GridStyle The GridStyle property specifies whether a column chart shows its x-axis, its y-axis, both, or neither.

Example: The following excel file is used for this exercise Chart-controls.xlsx.
Step 1: Insert a Column chart control.

Column chart in Power Apps
Column chart in Power Apps

Step 2: There is a Text label control in the group, used to specify the title of the chart. By default, its name is ‘Chart Title’. We can modify it as per our requirement.

Column chart in Power Apps

After updating the text of the Label control.

Column chart in Power Apps

Step 3: Select the Column chart control and set its Items property to the data source.

Column chart in Power Apps

After updating the Items property of column chart.

Column chart in Power Apps

Step 4: There is a Legend control in the group.

Column chart in Power Apps

Step 5: Select the column chart. Set the ItemsGap property to value 20. By default, its value is 0.

Column chart in Power Apps

We can see that the columns have gap in between them after setting the value ItemsGap to 20.

Column chart in Power Apps

Step 6: The Markers property specifies whether the data points are visible on each data point. By default, its value is true.

Column chart in Power Apps

Step 7: Select the column chart and set the GridStyle property value to All.

Column chart in Power Apps

After changing its value to All.

Column chart in Power Apps

Step 8: Select the column chart and click on the Advanced, scroll down and change the Labels dropdown value to name to display the Name column value below the chart.

Column chart in Power Apps

After changing the Labels choice value.

Column chart in Power Apps

Step 9: We can drag the Legend control and place it in the group, where we like.

Column chart in Power Apps