Create a model-driven app system chart

In this article you learn how to create a system chart. System charts are organization-owned charts, which makes them available to anyone with access to read the data running the app. System charts can't be assigned or shared with specific app users.

Note

Model-driven apps not configured to display All charts for a table will need newly created charts selected for the table within the app designer. More information: Add table assets

Create a new chart

  1. Sign in to Power Apps.

  2. On the left navigation pane, select Dataverse and then the table which requires a chart.

  3. Select Charts from the menu, and then select Add Chart.

    Steps to introducing a chart into a table.

    A new window opens where you can create a chart.

  4. Specify the type of chart, and how the data is displayed in the chart.

    • Enter the chart name, such as Number of employees by account.

    • In the Select Column dropdowns:

      • In the Legend Entries (Series) dropdown list select a column, such as Number of Employees.
      • In the Horizonal (Category) Axis dropdown list select a column, such as Account Name.
    • Add a description to identify the purpose of the chart, such as This column chart displays the number of employees by account name.

    Description to identify the purpose of the system chart you create.

  5. Select Save and Close.

The Number of employees by account chart is now displayed in the app designer list of charts available for the account table.

View your visualization in a model-driven app

Now that the chart has been created, it can be used to visualize table data in the model-driven app. Follow these steps to view the chart:

  1. Open a model-driven app that contains your table via a solution or open the app directly from the Apps area.

  2. Select ... next to the app, and then select Play. The model-driven app opens in a separate browser tab.

  3. On the left navigation pane, select a table such as Accounts.

  4. On the command bar, select Show Chart.

    The chart pane opens.

    Chart selector.

  5. By selecting the dropdown chart list, any of the system charts in the app will be available to select.

    The chart appears in-line with the data view.

    Your system chart named Number of employees by account is displayed.

Use your chart:

  • Select a bar on the chart to filter the data in the view.
  • Refresh the chart to display other data by changing the view.
  • Add the chart to a model-driven app dashboard. More information: Create or edit model-driven app dashboards

Note

If the chart is not visible in the dropdown chart list then the model-driven app has been created with specific charts associated with it. To resolve this, open the model-driven app in design mode, select charts, and then select your newly created chart. Select Chart from within app Then save and publish your app.

Known chart creation issues

In the chart designer, adding a order by on certain calculated columns are not supported and will cause an error. The calculated columns causing this are using another calculated column, a related table column, or a local column on the table.

Next steps

Create or edit dashboards