Power BI Dashboard Design: A Practical Guide

A Power BI page that looks impressive is not the same as one that works. A working page answers a known question at a glance, lets the reader explore without getting lost, and loads fast enough that they keep using it. Microsoft's own design tips come down to one idea: make the most important information stand out, and keep everything else clean and uncluttered (Microsoft Learn: dashboard design tips). This guide turns that into decisions you can make on every page.

Reports and dashboards are different things

In Power BI the two words mean different objects. A report is built in Power BI Desktop or the service, can have many pages, and is fully interactive. A dashboard is a single page of tiles pinned from reports, created only in the Power BI service, and meant as an at-a-glance overview with the details a click away in the underlying reports (Microsoft Learn: dashboards). Most design work happens in reports; a dashboard, if you build one, should only show what readers need to monitor.

Start from the audience and their questions

Before placing a visual, answer Microsoft's audience questions: how will people use the page, which metrics drive their decisions, and what do they need to succeed? Then write the three to five questions the page must answer, in the reader's words. Every visual on the page should answer one of them. Also decide where it will be viewed: a large monitor can carry more content than a laptop, and phones need a separate, simpler layout.

Lay out the page

• Keep it to one screen. Avoid scroll bars on a page meant to be read at a glance.
• Most important first. Readers start at the top left, so put the headline numbers there and add detail moving right and down.
• Use cards for key numbers. Cards make an important figure stand out, but always give context, such as the change against last year or the target; KPIs and cards covers designing them.
• Align to a grid. Consistent spacing and aligned edges make a page look deliberate; View options in Power BI Desktop include gridlines and snap to grid.
• Group related visuals and separate unrelated ones with space, not heavy borders.

Choose visuals by the question

Microsoft's guidance on visual choice is specific:

• Comparing values: bar and column charts, because people compare lengths side by side easily.
• Part of a whole: a pie chart only with fewer than eight categories, and never to compare the parts.
• Status against a goal: a gauge can work, though a card with a target and variance is often clearer.
• Avoid 3D charts and variety for its own sake.
• Sort deliberately: by the measure to highlight highest and lowest, by the category when readers need to find a specific item.

Numbers, time and scales

• Show three or four significant digits and scale to thousands or millions: "3.4 million" reads faster than "3,400,000".
• Keep time frames consistent. Do not place last month's figure next to a chart filtered to a different month.
• Keep scales, category order and colours consistent across charts, so the same product has the same colour everywhere.
• Avoid mixing large and small measures on one axis; use a secondary axis or separate visuals.
• Remove unnecessary data labels.

Colour with a purpose

Use a neutral palette for most of the page and one accent colour to draw attention, and reserve red and green for status. A report theme keeps this consistent across pages; themes and branding shows how. Apply conditional formatting to exceptions only; conditional formatting in Power BI covers the options and a common mistake.

Interactions and navigation

By default, selecting a data point filters or highlights every other visual on the page. Check each pair with Edit interactions and switch off interactions that confuse. For navigation, use buttons and a page navigator rather than relying on page tabs, and use bookmarks for alternative views of the same page; bookmarks and buttons covers both. Put detail on drillthrough pages that open for a selected item, rather than crowding the main page; drillthrough and drilldown explains the difference.

Accessibility

Microsoft's accessibility guidance asks report authors to add alt text to visuals, set a logical tab order, give visuals clear titles and labels, ensure sufficient contrast, and avoid using colour, including conditional formatting, as the only way of conveying information (Microsoft Learn: accessible reports). These changes also make the page clearer for everyone.

Speed is part of design

Every visual sends queries, and a slow page goes unused. Microsoft's guidance for DirectQuery models recommends limiting the number of visuals per page and disabling unnecessary interactions, advice that helps any model (Microsoft Learn: DirectQuery). Use Performance Analyzer in Power BI Desktop to find the slowest visuals before publishing.

Mobile layout

Power BI lets you create a separate mobile layout for each report page. Rearrange the most important visuals into a single vertical column and leave out the rest; designing for phones covers it in detail.

A review checklist for any page

1. Can a new reader state the page's main message within ten seconds?
2. Does every visual answer one of the written questions?
3. Are the headline numbers top left, with context?
4. Are numbers scaled and rounded, and time frames consistent?
5. Is colour used for meaning, with a second cue besides colour?
6. Have interactions been checked, and does navigation work without the page tabs?
7. Does the page load quickly in Performance Analyzer?
8. Do alt text, titles and tab order make sense with a screen reader?

For design principles that apply beyond Power BI, see dashboard design principles for analysts.

Dashboard design and storytelling, including interactive dashboards and UI and UX best practices for BI reports, are part of the Power BI course.

Sources

• Tips for designing a great Power BI dashboard (Microsoft Learn) — Microsoft Learn
• Introduction to dashboards for Power BI designers (Microsoft Learn) — Microsoft Learn
• Design Power BI reports for accessibility (Microsoft Learn) — Microsoft Learn
• DirectQuery in Power BI (Microsoft Learn) — Microsoft Learn