Skip to main content

Choosing the right chart for your Power BI reports

So your company has lots of good data that can be used for business decisions, the BI team started building a dashboard, but when management looks at the dashboard they are confused and can’t really see any business value in those colourful reports.

Data visualization is all about storytelling, if the data is out of context the story might be unnoticed.

So how do we choose the right graph or chart for our dashboard?

Bar chart

Bar charts are among the most frequently used chart types, and its simply because it’s easy on the eyes. With bar charts, the user can quickly identify which bar is the highest or the lowest, including the incremental differences between bars, its also a good way to illustrate both positive and negative values in the dataset. Use a Bar chart when you want to present the development or performance of a category. It’s best to have a limit of 5 categories to compare in most cases.

Line Chart

This type of chart is the best solution for analyzing and illustrating trends in data over time: it is very easy to read, and the user doesn’t feel overwhelmed or lost in data. Use this chart if you want to track the development of several variables at the same time. For example, analyzing year-over-year profit, department growth and even sales data over months, quarter, or years. It’s best to limit the number of lines to five or fewer to maximize visual comprehension.


Use tables if you want to enable readers to look up specific information or exact values. Readers will be able to find details and go deeper into the data based on the information they gathered from the charts. Use tables when your data cannot easily be presented visually, or when the data requires more specific attention. Don’t use table if you want to find trends or compare data sets.

Matrix Tables

A matrix chart is like an advanced table, it shows relationships between two or more variables in a data set. If you want to display data across multiple dimension (rows and columns) Matrix Chart is the best option.

Donut chart

A donut chart, in its simplest form, is a pie chart, except it has a blank center and the ability to display information inside it. Many report developers avoid using Pie Charts because it is difficult to visually compare the proportional areas of the slices to one another and to the chart as a whole. This makes it tricky to see the differences between slices. Donut charts resolve this issue when the readers focus more on reading the length of the arcs, rather than comparing the proportions between the slices.

By choosing the best visuals in the right context in a Power BI report, your viewers can more easily understand the data and make decisions or discover insights about their business.

Let us build something amazing together
Connect with us.

With over 20 years of experience working with Microsoft Technologies, Imaginet can help you choose the right Microsoft 365 solution to adopt an effective hybrid workplace model and improve employee engagement. Contact us to get your free virtual consultation.

Let's Talk

Like what you read?

Check out our recent articles.

March 16, 2023 in Application Development

Choosing the right technology stack

Choosing the right technology stack is crucial to the success of any software development project. It involves selecting the right set of tools and frameworks that can meet the project's requirements and help deliver high-quality results within the given time and budget. At Imaginet, we understand the challenges and complexities that come with selecting the right technology stack, and we are committed to helping our clients through the process. Here are five tips to consider…
Read More
March 9, 2023 in Power Platform, Productivity

The Ultimate Guide to Creating High-Performance Power Automate Workflows

Learn how to create powerful Power Automate workflows that are efficient, effective, and designed for success. This ultimate guide covers everything from setting up your workflow to advanced customization options and best practices. Get started on your journey today!
Read More
March 1, 2023 in Application Development

Optimize Learning & Efficiency of App Development with ChatGPT

The article discusses how artificial intelligence (AI), specifically the AI-powered language model ChatGPT, can be integrated into software development processes. ChatGPT can be utilized for tasks such as providing explanations for coding concepts, giving recommendations for improving code efficiency, simplifying complex code, troubleshooting and debugging code, and generating examples for practice exercises.
Read More
February 22, 2023 in Modern Workplace, Office 365

Uses of Intune in a Remote Work Environment

Microsoft Intune is the perfect solution to help you manage and secure your remote work environment. It provides easy access to all your apps, data, and resources while ensuring compliance with organizational policies. Get started today and make sure your remote work environment is safe
Read More
Mika Dashevsky

Data Engineer, Solution Consultant at Imaginet

Let‘s Talk.

Let's talk!