Microsoft’s Power BI dashboards tell a story and reveal key insights and patterns that could otherwise be lost in data sheets, allowing organizations to make better, more informed and faster decisions. The good news is you don’t need to be an IT expert to create a Power BI dashboard.

SEE: Explore our list of the best business intelligence tools.

Dashboards can be built in Power BI from one or several reports by importing datasets or duplicating an existing dashboard. Unlike reports — which may have multiple pages — dashboards are a single-page canvas. These dashboards can be updated to show the latest data, but they cannot be filtered like reports, nor can they be edited.

What is a Power BI dashboard?

In Power BI, a dashboard, also known as a canvas, is a single page that presents the key metrics and data with high-impact visualizations (Figure A). Designing dashboards efficiently is critical as they are one of the main sources for data-driven decision-making.

Figure A

Microsoft Power BI dashboard displayed on a tablet, desktop monitor, and mobile phone
Power BI dashboard. Image: Microsoft

Power BI dashboards are used by executives, managers, team leaders, analytics and business leaders to track key performance indicators, drive decisions, communicate and present data, and work to meet business targets. As Power BI users advance, they can leverage more powerful features, for example using data analysis expressions.

SEE: Here’s how to calculate profit margin in Microsoft Power BI using a calculated column.

What to consider before creating a dashboard in Power BI

Before building a dashboard, you should think about what information you need to highlight. For example, a sales-focused organization may want its dashboard to include data on total sales, best-s products, sales over time, units by sale, sales by region and top segments.

Also, each organization should personalize its dashboard according to its goals, operations and efficiencies; there is no one-size-fits-all solution or approach.

Users should also understand that dashboards are a Power BI service, and they’re not available in Power BI Desktop.

How to create a dashboard from a report

If you don’t have your reports in Power BI, you can import your dataset as an Excel file.

Import Excel data to Power BI

  1. Open the Power BI service in your browser.
  2. From the navigation pane, select My Workspace, and then, click Get Data at the bottom of the menu.
  3. Under Files, select Get.
  4. Find your Excel file and click Connect.
  5. Select Import, and Power BI will automatically import the data.

Now that you have your report on Power BI, you can start building your dashboard.

Build a dashboard in Power BI

Dashboards are created by pinning tiles from a report to a new dashboard. It’s possible to pin an entire report to a dashboard or pin individual tiles from one or several reports. To do so:

  1. Select and open the Excel file report that will be part of the new dashboard.
  2. Select More options (…), then Edit to open the report in the Editing view.
  3. Hover over a visualization. This will reveal the hidden options. Select the Pin icon to add the tile to the dashboard (Figure B).

Figure B

A bar chart tile added to a Microsoft Power BI dashboard
To add a tile to the dashboard, click on the Pin icon. Image: Ray Fernandez/TechRepublic
  1. Select New Dashboard, then name it (Figure C).

Figure C

Menu pop-up to choose to pin the Excel chart tile to a new or existing Microsoft Power BI dashboard
Choose to pin the tile to the dashboard by selecting the New Dashboard option and then name your dashboard. Image: Ray Fernandez/TechRepublic
  1. Click on Go To Dashboard.

The tile you pinned should now be the only visualization in your new dashboard. To pin more tiles, return to a report and repeat the process. Remember, when adding more tiles, click on Existing Dashboard and select the name of your new dashboard from the dropdown menu.

SEE: Now, learn how to create relationships in Power BI.

How to pin a tile from Excel to a Power BI dashboard

Alternatively, if you already have a dashboard set up in Power BI, you can borrow from Excel workbooks to emphasize key data points in your dashboard. To do that, you must first connect the Excel workbook you want to pin to your Power BI service. When a workbook is connected, a read-only version is saved, allowing you to pin ranges and entire worksheets to dashboards.

Connect an Excel workbook from OneDrive to Power BI

  1. Upload the workbook to your OneDrive.
  2. Open Power BI and go to My Workspace, then Upload > OneDrive for Business (Figure D).

Figure D

The Upload dropdown in My Workspace with OneDrive for Business selected
Under My Workspace, users can upload Excel files through OneDrive for Business. Image: Microsoft
  1. Next, search for your saved Excel file, select it and choose Upload.
  2. Now you should see the workbook added to Power BI in your workspace.
  3. Finally, open the workbook in Power BI by selecting the workbook you uploaded.

It’s important to remember that any changes you make to the workbook in Power BI don’t affect the original workbook file saved on OneDrive for Business.

Now that you have connected to a workbook, you can pin a range of cells to your dashboard.

Pin a range of cells or a table to a dashboard

  1. Highlight the cells you want to pin to a dashboard (Figure E).

Figure E

A dataset in Microsoft Excel highlighted
To start, highlight the cells you want to pin to a dashboard. Image: Microsoft

You can even select a range of cells or an entire table or PivotTable. To pin a table, select the entire range and include the headers. To pin a PivotTable, be sure to include every visible part of the PivotTable, including filters if used.

  1. Select the pin icon.
  2. Pin the tile to an existing dashboard or to a new dashboard and confirm the operation by selecting Pin.

Once you have pinned the cells, you can edit the dashboard tile. Power BI can also connect with Microsoft Lists.

How to customize a dashboard in Power BI

Now that you’ve created your dashboard, you can personalize it in a variety of ways to ensure the information is presented in a way that suits you and your business’s needs.

How to edit and manage tiles in Power BI dashboard

Once the tiles are added to a Power BI dashboard, they can be easily modified and personalized. To resize tiles, the bottom right corner of the tile must be dragged, similar to resizing an image on a photo editor. The placement, appearance and behavior of titles can also be modified.

Change the title of the tile

  1. Select the More Options Menu (…) found in the upper-right corner of the title.
  2. Select Edit Details to open the Tile Details window.
  3. Change the title of the tile and add a subtitle if required.

In the same Tile Details window, users can change the behavior of the tile. Power BI sets the default behavior for each tile to direct users to the source report. However, that behavior can be changed to direct users to another dashboard, or report, by changing the default hyperlink in the Tile Details window.

Change the behavior of a tile

  1. In the Tile Details window, select Set Custom Link.
  2. Select Link and select where you want the tile to redirect users from the dropdown menu.
  3. Select Apply.

Dashboards are all about clear insight. Graphs, charts and other types of visualizations are key. There is a wide range of visualizations available on Power BI that can be combined to create a dashboard that not only looks good but drives performance and analysis.

Change the type of tile visualization

  1. Open the report that has the visualization you want to change.
  2. Select the visualization to make it active. Note that when the visualization is selected, it should show handles and a border.
  3. In the Visualizations pane, find and select the new type of visualization.
  4. Pin the Tile with the new visualization to your dashboard by clicking on the Pin icon.

Through the More Options menu (…), users can also add comments, copy the visual as an image, open in focus mode, export, view insights, delete the title and manage alerts.

SEE: Discover some of the best data visualization tools.

How to change the theme of a dashboard in Power BI

The theme of a dashboard can also be changed. Power BI has three themes to choose from: Light, Dark or Color-blind friendly. A dashboard’s theme can even be personalized by selecting the Custom theme option.

To change the theme, select the edit dropdown menu, then the Dashboard theme, choose the theme and click Save (Figure F).

Figure F

Example of a customized Power BI theme in black, red, yellow, green, and gray
Example of a customized Power BI theme. Image: Microsoft

As endpoints become the new workplace, dashboards need to work efficiently across all devices including mobile. With Power BI, users can personalize a dashboard for mobile viewing.

How to add images, videos and more to your dashboard

Power BI allows users to add a tile to a dashboard and place images, text boxes, videos, streaming data or web content in the tile.

To add an image or video to a tile:

  1. On the top menu, open the Edit menu (pencil icon) and then select Add a tile.
  2. Now select what type of tile you want to add. Options include web content, image, text box, video and custom streaming data (Figure G).

Figure G

Different tile options available in Power BI, including web content, images, text boxes, videos, and custom streaming data
Power BI gives users the option to add different types of content to a tile. Image: Microsoft
  1. Before adding an image or a video you need to upload the file online, making sure security credentials aren’t required to access the file.
  2. In the Add tile window, click on Image or Video and then on Next.
  3. Now add the image or video, title, optional subtitle and URL of the image or video you uploaded. You can also create a hyperlink for the tile in this step (Figure H).

Figure H

Add image tile dialog box with fields for Title and Subtitle, URL, Functionality and other details
Enter the title of the image, the URL of the image and other data when adding images. Image: Microsoft
  1. Click on Apply.
  2. Finally, you can edit the tile, resize and move the content directly on the dashboard.

Users can follow the same steps to add text boxes, streaming data such as Twitter feeds or sensor data and web content via embedded code.

How to customize a dashboard for mobile view

First, select View, then click on Mobile Layout. Power BI will show you an emulated mobile version of the dashboard. Here, you can resize tiles, change information and move tiles. The mobile view can also be customized according to the different devices used to view the dashboard (Figure I).

Figure I

Tiles available to set up on a mobile device with an example phone screen displaying tiles stacked one above the other
Customize the tiles for viewing on a mobile device. Image: Microsoft

Power BI has several more advanced features for dashboards. From configuring real-time data to data classification or monitoring sales, each organization can make the most of its data by building its dashboard.

How to set alerts in Power BI

Alerts are a useful feature for Power BI dashboards. Each tile can manage alerts, and these can be available to anyone who has access to the dashboard. For example, a logistic manager may configure personalized alerts for each worker in different locations to make a supply chain run smoothly.

Alerts are sent to the Notification Center of Power BI, but users can also configure alerts to be sent to emails. To set alerts:

  1. Select the More Options menu (…).
  2. Click Manage Alerts.
  3. Click Add Alert Rule. Make sure the Active switch is set to On (Figure J).

Figure J

Manage alerts menu in Power BI with the option to Add alert rule and a sample alert for Alert for Market Share turned on
In the final step, click on Add Alert Rule but make sure the Active switch is on. Image: Ray Fernandez/TechRepublic
  1. Set the threshold for the alert. Thresholds can be Above, Below or Specific.
  2. Set the frequency of the alert.
  3. Save and close.

How to create a QR code for a tile in Power BI to use in mobile apps

You can generate QR codes to seamlessly connect to data on a tile, creating a more interactive experience. QR codes can be created for tiles in any type of dashboard, even those where editing is prohibited.

QR codes can even be printed or emailed, but more commonly, they are scanned using smartphones. Users that scan the QR code will get instant access to the tile on their mobile device.

SEE: Here’s how to design and review reports for mobile devices in Power BI.

To create a QR code for a tile:

  1. Open any dashboard in your Power BI.
  2. Go to More Options (…) in the upper right corner of a tile and choose Open in focus mode.
  3. Next, select More Options (…) at the top right and choose Generate QR Code (Figure K).

Figure K

Power BI menu dropdown with Generate QR Code selected
In the top right, under More (…), select Generate QR Code. Image: Microsoft
  1. A dialog box with the QR code will appear (Figure L).

Figure L

Power BI Your QR code is ready pop-up with a sample QR code visible for users to download
Example of how Power BI presents users with a uniquely generated QR code to scan, download, or save. Image: Microsoft
  1. Now you can scan the QR code, save it, or download it.

Subscribe to the Developer Insider Newsletter

From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays

Subscribe to the Developer Insider Newsletter

From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays