Dashboards in Model driven apps
Updated: Nov 22
Dashboards are collections of charts relating to Microsoft Data verse tables.
There are two types of dashboards :
An app user can create a dashboard visible only to them in the app areas where they have privileges.
An admin or customizer creates or customizes system dashboards that, when published, are visible to all app users.
A user can choose to set their user dashboard as their default dashboard and override the system dashboard.
Dashboards can be standard or interactive
Standard dashboards support adding one or more unrelated components such as charts or lists.
Interactive dashboards provide the capability for users to act on a particular row directly from the dashboard.
Create a new Standard Dashboard
Sign into Power Apps (make.powerapps.com).
Select Solutions, and then open the required solution.
On the toolbar select New, select Dashboard, and then choose one of the following layouts :
3-column overview (varied width)
Power BI embedded
In the Dashboard: New page, enter a name for the dashboard.
Select one of the component areas and then select the icon for a chart or a list.
Up to six components can be included in a dashboard.
For example, to add a chart, select the chart icon on the tile of the dashboard canvas where the chart needs to appear. Then, in the Add Component dialog, select values for Row Type, View, and Chart. Then select Add to add the chart to the dashboard.
When finished adding components to the dashboard, select Save and then Close.
On the solution toolbar, select Publish.
Edit an existing dashboard
1. Sign in to Power Apps
2. Select Solutions, and then open the required solution.
3. In the list of solution components, open the dashboard, select one of the component areas, and then on the toolbar select Edit Component.
4. In the Set Properties dialog box, make changes to a chart or list such as change the table, default view, add a chart selector, or make the dashboard available on the mobile apps. When done, select OK.
5. When the changes are complete select Save and then select Close.
6. On the solution toolbar, select Publish.
Configure a multi-stream interactive dashboard using the 4-column layout
1. Sign in to Power Apps
2. Navigate to an environment with an unmanaged solution.
3. Select Solutions, open the solution required, and then on the toolbar select Switch to classic.
4. In the left navigation pane, select Dashboards, on the toolbar select New, and then select Interactive Experience Dashboard.
5. Choose the layout, either 2, 3, or 4 column width.
6. When the dashboard form opens, fill in the filtering information at the top of form, as shown here.
Filter Table: The visual filters and global filter attributes are based on this table.
Table View: The visual filters are based on this view.
Filter By: The column that the time frame filter applies to.
Time Frame: The default time frame filter value for the Filter By column.
After filtering information has been specified, start adding components for the charts and the data streams. To add a component, simply select the element in the center of the chart or stream, and when the dialog appears, select the required information from the drop-down list, as shown in the following illustrations.
Add the Cases By Priority doughnut chart
Some charts, such as bar charts or pie charts, render showing the data stored in the system. The doughnut charts and tag charts load as static images and don’t show the preview of the actual data.
Next, configure the streams. Just like with adding components in the charts, select the element inside the stream panel. When the dialog appears, select View or Queue depending on what element you want the stream to use. Enter the required information, as shown in the following illustration.
Configure the stream for the Items available to work on as shown here:
The following illustration is an example of a fully configured chart panel and stream panel :
After the dashboard has been completely configured, save it and publish the customizations for the changes to take effect.