Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
APPLIES TO:
Power BI Desktop
Power BI service
When you create a dashboard and add some tiles, think about how to make your dashboard both visually interesting and functional. In general, you want the most important information to stand out and be clean and uncluttered.
Tip
Like this dashboard? You can download the related sample and reports from AppSource. In Power BI (app.powerbi.com
), select Learn in the left navigation. On the Learning center page, under Sample reports, locate the Sales & Marketing Sample. Select the sample to download.
Watch Dashboard design best practices in Power BI for design tips from Marco Russo of SQLBI.com.
When you optimize the dashboard layout for your audience, consider the following scenarios:
Keep in mind that the dashboard is an overview, a single place to monitor the current state of the data. The dashboard is based on underlying reports and semantic models, and those items often contain many details. Your readers can drill into the reports from your dashboard, so don't put a detail on the dashboard unless that's what your readers need to monitor.
Where is the dashboard going to be displayed? If the dashboard is viewed on a large monitor, you can include more content. But if readers view your dashboard on their tablets or phones, a dashboard with fewer tiles is more readable.
Because dashboards are meant to show important information at a glance, having all the tiles on one screen is best.
When presenting a dashboard, display it in full-screen mode and without distractions.
If text and visualizations on a dashboard are the same size, readers might have difficulty focusing on what's most important. To highlight information, card visualizations are a good way to display an important number prominently:
Be sure to provide context for your visualization.
Read about how to create a tile with just a number.
Most people read from top to bottom. Put the highest level of data at the top left corner, and show more detail as you move in the direction the audience uses for reading (left-to-right, top-to-bottom).
Avoid visualization variety for the sake of variety. Visualizations should paint a picture and be easy to read and interpret. For some data and visualizations, a simple graphic visualization is enough. Other data might need a more complex visualization. Use titles, labels, and other customization to help the reader.
Here are some helpful tips:
Avoid visuals that are hard to read, such as 3D charts.
Pie charts, donut charts, gauges, and other circular chart types aren't ideal data visualizations.
Be consistent with chart scales on axes and chart dimension ordering. Be consistent with the colors used for dimension values within charts as well.
Be careful encoding quantitative data. Don't exceed three or four numerals when displaying numbers. Display measures to one or two numerals left of the decimal point and scale for thousands or millions. It's easier for humans to read the value "3.4 million" rather than 3,400,000.
Don't mix levels of precision and time. Make sure time frames are distinct and consistent. Don't have one chart that has last month next to filtered charts from a specific month of the year.
Avoid mixing large and small measures on the same scale, such as on a line or bar chart: for example, one measure that's in the millions and another measure that's in the thousands. With such a large scale, it's difficult to see the differences of the measure that's in the thousands. If you need to mix measurement scales, choose a visualization that allows the use of a second axis.
Remove unnecessary data labels from your charts. The values in bar charts can usually be understood without displaying the actual number.
Pay attention to how charts are sorted. If you want to draw attention to the highest or lowest number, sort by the measure. If you want people to quickly find a particular category within many other categories, sort by the axis.
For more visualization-specific guidance, see Visualization types in Power BI.
To become an expert in the art of excellent dashboard design, consider learning basic Gestalt Principles of visual perception. The principles help you learn how to clearly communicate actionable information in context. Luckily, there are many resources already available within our blogs and docs, such as Basic concepts for designers in the Power BI service.
Here are a few book recommendations:
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Learning path
Design effective reports in Power BI - Training
This learning path introduces a design process to design and deliver compelling Power BI reports. It begins by describing a proven design process created by leading report design experts. The process encompasses phases to understand the report users and their requirements, explore pleasing report designs, and develop reports all the way into production.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.