Power BI donut diagram (2023)

Why use a donut chart?

The advantage (some might say downfall) of Power BI's donut chart is its simplicity and ease of displaying analog data. A bar chart can only show data from one place to another, while a Power BI pie chart and donut chart show from one place to anotherhole data. On adonut chart, each slice represents the proportion of each row or category.

So you can immediately see how useful Power BI's donut chart is – you can analyze data to compare, for example, a budget, demographics, survey results, and more. The donut chart tells you what is more and less of something.

Power BI donut diagram (1)

How to make a good donut graphic?

A donut chart works best when its individual parts add up to a whole. Its purpose is to illustrate how each part contributes to that whole. The inherent circle of the donut chart means that it carries 100% implication, making it intuitive for everyone. This is why many report viewers can actually request a Power BI donut chart in a report, as it is a universally recognized form.

To create a Power BI donut chart, simply select or drag the donut image of your choice, built-in or custom. When you configure a Power BI donut chart usingDonut PRO breakdown, you only need two fields. You have the category, which is the field that defines your hierarchy. There you extract different columns from your data sources. And the second field will be Values ​​which accepts both columns and measures.

And just like that, you've created your first Power BI donut visualization using Drill Down Donut PRO. Then you can focus on customizing and formatting. The same steps work when creating a Power BI pie chart.

Power BI donut diagram (2)

How do you interact with a donut chart?

Donut PRO breakdownis one of the best examples of the evolution of the donut chart when it comes to Power BI reporting. It has many useful plugins for Power BI built-in donut chart to fully unlock interactive data visualization possibilities. Some of them include:

  • Filter between charts or be able to use a Power BI donut chart as a slice (more on that later) instead of clicking through Power BI's built-in analytics individually.

  • Analyzing the left-click allows for a more streamlined data browsing experience rather than enabling this feature individually, one right-click at a time. It also works well with filtering between graphs.

  • Left-click and hold to select and filter a slice without going down to the second level of the Power BI donut chart. You can also do this with multiple slices by holding down the CTRL key as you click.

  • Animated interactions that help the end user follow the data storytelling experience.

  • Desktop and mobile navigation so you can intuitively explore data anywhere, anytime. The one-click drills mentioned above are easily integrated into touch mobile devices.

Power BI donut diagram (3)

What are some ideas for incorporating donut charts into reports?

There are many useful ways to incorporate a Power BI donut chart for interactive storytelling. Here are some ideas for using Power BI donut charts with some added enhancements from Drill Down Donut PRO.

(Video) Create stunning Multi Layered Donut chart in PowerBI | MiTutorials

  • Filter the remainder of the report page with a donut chart

Because the Power BI donut chart is great for efficiently displaying categorical data, you can use it as a filter for the rest of the report page. Each time you click on a part it acts as a filter for the rest of the report. You can also select multiple sections with CTRL + click and apply them as a filter. To reset, simply click outside the chart or use the reset button provided with the zoom chartsConsidere PRO Visuals.

Power BI donut diagram (4)

By using this method, you don't have to use slicers to filter the rest of the report, but save screen space and make your reports more interactive.Using a donut as a filter can also be applied to many other chart types. Just to name a few - Map, TimeSeries, Graph and more. This makes your reporting easy and intuitive for everyone.For example, if you have a lot of data points in your map visualization, it can be difficult to sort and filter them. Placing a donut next to it is an easy way for the end user to see all the categories on the map chart so they can click on the right slice and filter accordingly.

Power BI donut diagram (5)

This is great for interactive storytelling and gives the end user complete flexibility when navigating the Power BI report. By combining Power BI donut chart visualizations with other chart types, the end user gets the best of both worlds – a larger proportional view of each category and a more concise view of other charts.

  • "Second" disc.

So, one of the biggest disadvantages (some might call it an unavoidable flaw) is the fact that a Power BI donut chart cannot show many categories at once, otherwise the chart will become unreadable. To combat this, you mustDonut PRO breakdownThe visual lets you add an "Other" track. We've covered the ins and outs of the Other section in ourprevious post.All in all, it's a great way to avoid messing up your report when the total number of pieces in your donut exceeds 5-6. This feature is also incredibly useful for Power BI pie charts.

Power BI donut diagram (6)\

  • inner donuts

Putting a ring inside your ring might seem redundant, but it's a great way to add subcategories and show hierarchical relationships in a single Power BI ring chart. The inner donuts show the previously selected categories. They retain their size and color for easy reference. This helps the end user to retrace their previous steps so they don't get lost while exploring the Power BI donut chart.

This works well when combined with the outer ring we added.Donut PRO breakdown. The outer ring indicates that the donut chart has another layer available for you to analyze. Coupled with the inner donut shown, this makes for a very seamless data browsing experience, helping the end user to position themselves in the data.

Power BI donut diagram (7)

We also mentioned that the built-in donuts are great for adding subclasses. Why do you want subcategories? Adding subcategories allows you to create an interactive slicer where you can take a closer look at how those subcategories perform against the parent category as a whole. The inner donut lets you see it all on the surface. So, with just one donut, you can e.g. see Team > Team Member > Product. Viewing everything on one level improves the user experience and readability of reports.

The Drill Down Donut PRO itself supports up to 9 levels of drilling. But it's best to keep it around 3-4, as going deeper will end up with overly specific filters, which can be counterproductive in practice. As a solution, you can always split the view into 2 different charts and apply filtering between the charts.

And remember, it's about choosing the right colors and smart sorting to avoid confusing the end user and instead help them discover some powerful ideas and comparisons.

  • bottom fill color

We put a lot of thought into improving the UX when there are multiple images presenting the same data metric on the screen. And this is the incredibly simple and powerful solution that we came up with, which just uses color as an indicator. When visualizing multiple categories and subcategories using a Power BI donut chart, it's a good idea to assign a specific color and keep each slice within the same tonal range. With the Drill Down Donut PRO, you can easily achieve this with the Base Fill Color setting.

Power BI donut diagram (8)

One of the key benefits of setting the base fill color is that by using the same metric for multiple charts, you can assign the same base color to the corresponding Power BI pie or donut for easy reference. It just makes it easier for the end user to understand what they are seeing, as well as navigate the graph if there are a lot of images on the screen. Or you can choose a monochromatic look for your reference if that's your style.

What are some use cases that have a thread diagram?

Some might say that the only good use case for a Power BI donut chart is when you have some high-level elements to visualize and you want to compare those elements or see how they contribute to a whole. Really, a Power BI donut chart can be used in many clever ways, it all depends on the designer. Just remember that the point of a donut chart is that it implies 100% integer.

The most popular uses for donut charts include:

(Video) 2.4 How to create a Donut Chart in Power BI | Power BI Tutorials for Beginners | By Pavan Lalwani

  • Accounting and finance – income or expense analysis, invoicing.

  • Project management – ​​risk allocation and resource allocation.

  • Human resources – composition of staff, salary distribution, responses to surveys (with some exceptions).

  • Sales and Marketing - sales and campaign data, KPIs, sales team performance against total sales.

Power BI donut diagram (9)

When viewing the above, remember that this is about showing part-to-whole data or a category's place in the bigger picture. A donut chart cannot show the progress of your data and it doesn't work when you have ordinal variables. In short, it cannot display categories that have a temporally or socially dependent order – it is better to choose a different chart type at that point.

If you choose to show progress, you can use a donut to show capacity usage (similar to CPU) or as a way to measure completion against a set goal (goal is 100% of course). This would work well with something like a KPI, where you track how far a company is on its goals. However, when we go into the negative percentage or exceed our 100% target, it's best to consider using a different type of chart.

The Power BI donut chart can also serve as a starting point for presenting your report to the viewer. Because the donut chart is so universally recognized, it's very likely that an end user with less technical knowledge will start playing with a donut chart first as a warm-up before venturing into other charts. So keep this use of a Power BI donut chart in mind when thinking of ways to present interactive charts to end users.

What is the difference between a pie chart and a donut chart?

A Power BI donut chart does pretty much the same things that a Power BI pie chart can do. still shows proportional numbers. But there are some important differences.Donut charts take the simplicity aspect of pie charts one step further by cutting out the middle.

Power BI donut diagram (10)

In the case of Power BI pie charts, by assuming a circle as 100%, you end up comparing areas of that circle – how much space each slice occupies in the Power BI pie chart. And chances are, because of the sharp edges of each slice of the Power BI pie chart, your eyes will be drawn to the center rather than the outer arcs of each slice.

But if you cut it in half, the proportional relationships become more apparent. Each donut slice has the same width, like a slice in a Power BI pie chart, but a different arc length.The only thing you need to compare is the length of each donut slice/bow.This speeds up the graph reading process for the end user, as he only needs to compare the length of each arc.

The empty center of a Power BI donut chart can also be used as a clever way to display some key numbers in the data you are working with, or you just want the extra negative space in your report for aesthetic reasons if aren't a big fan of Power BI's multitude of pie charts. Your donuts don't always have to be thin, so feel free to play around with the width and size of this gap.

Because donut charts use fewer pixels, you end up with less space for categories.While anything up to 8 slices is still reasonable for a Power BI pie chart, with Power BI donut charts you should stop at 6 slices. A donut chart makes it easier to compare data sets due to the exclusion of a midpoint and better focus on arcs. But this comes at the expense of the number of categories you can include before it starts to look confusing.

What NOT to do with a donut chart and a pie chart?

The following list applies to Power BI pie and donut charts - don't force them to be something they're not. Yes, Power BI pie charts get a bad rap, but any chart can look terrible if the report builder forces that chart to do something that doesn't make sense.

  • Don't let each part of your graph add up to more or less than 100%.

If the purpose of a donut and pie chart is to measure a part-to-whole ratio, why would you make the sum total anything other than 100%? The answer is: you wouldn't. It makes no sense either in theory or in practice, so keep your donuts and pies at 100%.

Power BI donut diagram (11)

Often news outlets like to skew their graphics ratios to sell a specific narrative. Sometimes a clumsy mapping can reveal an ulterior motive other than carelessness.
At the other end of the spectrum, none of the donut slices in this graph make it to 100%. How can this happen;

(Video) Power BI Donut Chart in Hindi | Donut Chart in Power BI in Hindi

Power BI donut diagram (12)

Top product categories among Nordic online shoppers (PostNord, 2017)PDF

Most likely, each sample represents a percentage of buyers from the retrospective country who purchased each product category. So when compared, they shouldn't add up to 100% - but why use a donut chart? A bar chart would work better as it is a misuse of the donut and pie chart.

  • Don't view your pie and donut charts at an angle.

Unfortunately, this is a very typical pie chart seen in company annual reports.

Power BI donut diagram (13)

This case is given byIELTS caraas a written test. Luckily for most people who come across this particular pie chart, they just need to show off their English skills, so the numbers given are enough to get by even the tiny 0.4% slime. For real data analysts, an angular pie or donut chart can distort the proportions of the pieces, making true comparisons difficult.

Yes, it looks fancy, but on the other hand, it makes the chart completely useless. The display is distorted, making it difficult to calculate the proportions of each slice.

Power BI donut diagram (14)

impatient eyes

So this pie chart is supposed to show how often people share recommendations online. Aside from the crazy visual effects and the ability to display most of the dials with a white overlay for some reason (why is only one of them blue?), you can't compare the dials correctly because they are angled. Keep your angle simple with a top-down view of the pie chart.

  • Don't sort your categories by name.

This just clutters up the chart and confuses the end user's eyes, as you've just given them the task of sizing each piece. Avoid assigning tasks to end users that they are not registered for.

Power BI donut diagram (15)

This is an example that was discoveredunsolicited graphics.As you can see, sorting the slices alphabetically makes the pie chart more difficult to read. Best practice would be to sort by size, usually in descending order, and use colors to code data differences. For example, the Base Fill Color option found in Drill Down Donut PRO does just that.

  • Don't put too many categories in the donut or pie chart.

This takes away the visibility of the Power BI pie chart. You also run the risk of straining the end user's eyes. Imagine if the caption represented something other than emojis - if you were in the end user's shoes and saw this diagram, would you really understand what you're seeing?

Power BI donut diagram (16)

(Video) Donut Chart and Pie Chart in Power BI

And in case you were wondering - yes, this is a real custom-made pie chart.emoji frequency.

  • Don't try to show ranges or growth with donut or pie charts.

Power BI donut diagram (17)

Okay, so someone actually tried to solve the "too many categories" problem and thought this is a good way to get around the gaps that show up in a pie chart.

Granted, they're trying to show a salary range by position - but why use a pie chart for that? It's not very intuitive to read, as donut and pie charts will always have this implied as a whole or 100%. The slices here aren't a percentage of anything, they're just intervals.unsolicited graphicspresented a better way to visualize this type of data.

Ranges are very difficult to visualize with a donut chart as they risk exceeding 100% or even going into negative numbers. You simply won't be able to logically visualize this type of data with a Power BI pie or donut chart, so don't try to reinvent the wheel.

Is it a Donut or a Donut Chart?

Short answer: it's both. Slightly longer answer: "doughnut" is the generally accepted spelling, as most dictionaries would say. Most people would say that the shorter spelling of "donut" is only acceptable in American English. However, you will find that the shorter version has crept into other English-speaking nations through advertising.

When it comes to charts, feel free to use your preferred spelling, be it "Power BI Donut Chart" or "Power BI Donut Chart". But here at ZoomCharts, we're serious about charting. Therefore, we prefer to use the "doughnut chart", just to avoid too close a relationship with frosted treats.

Have we already given you ideas for your next Power BI donut chart? Give them life now withDonut PRO breakdown!

There's always more to come. Don't miss other Power BI news fromenrollmentin our newsletter!

Power BI donut diagram (18)

Subscribe to our newsletter

Sign up for our newsletter and receive our latest news, expert advice and practical guides on how to get the most out of our data visualization solutions!

(Video) PowerBI.Tips - Tutorial - Filled Donut Chart


What is the difference between a pie chart and a donut chart? ›

Pie charts consist of a circle divided into segments that represent the component parts of the whole. Donut charts are the same, but with a hole in the center. The axis for a pie or donut chart follows the circumference of the circle.

How do you make a donut diagram? ›

On the Insert tab, in the Charts group, click Other Charts. Under Doughnut, click Doughnut. Click the plot area of the doughnut chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

How do you make a 3D donut chart? ›

To build a 3D Doughnut chart, use the anychart. pie3d() chart constructor and the innerRadius() method to set the inner radius. The radius is 0 by default and can be set either as a value or a percentage of the chart's bounds.

How do I create a dynamic donut chart in Excel? ›

Create the Doughnut chart by selecting the data (cells A5 through B6) and insert a Doughnut chart (Insert (tab) -> Charts (group) -> Pie (category) -> Doughnut). The result will appear something like the following chart.

When should you not use a donut chart? ›

Challenges When Using a Donut Chart

If there are too many segments to represent and each of them occupies only a small portion of total data, the segments can be hard to read. A donut chart is not the best format to use when negative values need to be represented.

What is the benefit of a donut chart? ›

A donut chart can be used to visualize the proportion of total insured value (TIV) in each policy class. The donut chart above gives a visual representation of each policy class, with the total insured value in the center.

What is the advantage of doughnut chart over pie chart? ›

The pie graph gives a strong and immediate sense of overall proportions, whereas the donut graph leads the reader's eye around the arcs of the circle – and tend to creates more of a narrative. One advantage of the donut graph is that additional information can be displayed at the graph's center.

What can I use instead of a donut chart? ›

Table of Contents:
  • Stacked bar chart.
  • Treemap chart.
  • Donut Chart.
  • Waffle Chart.
  • Packed Bubble Chart.
  • Radar Chart.
Dec 5, 2022

Which type of chart will be most effective? ›

Line charts are the most effective chart for displaying time-series data.

What is a half donut chart called? ›

What is a half pie chart? A half pie chart (also, half moon or semicircle chart) is a 180 degrees graph that represents the composition of a whole. Its total arc area corresponds to 100%, and its slices illustrate the part-to-whole relationships. The half pie chart works like a regular pie chart.

What do you need to add to create multiple donut charts? ›

You'll need:
  1. One header row containing descriptive labels.
  2. One column containing at least two categories. This will determine the label in the donut slices. In our case, that's "bottom 50%", "next 40%" and "top 10%.
  3. At least one column containing numeric values. The values in the second, third, etc.
Aug 13, 2020

Is donut 2d or 3d? ›

In geometry, a torus (plural tori, colloquially donut or doughnut) is a surface of revolution generated by revolving a circle in three-dimensional space about an axis that is coplanar with the circle.

What 3d shapes look like a donut? ›

Shaped like a ball or a globe a sphere is a completely round object. Every point on the surface of a sphere is an equal distance to the centre of the sphere. Shaped like a ring, a tyre or a doughnut, a regular ring torus is formed by revolving a smaller circle around a larger circle.

What is bubble chart in Excel? ›

A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles. Just like a scatter chart, a bubble chart does not use a category axis — both horizontal and vertical axes are value axes.

What is a doughnut chart in Excel called? ›

The correct answer is Pie chart. Doughnut Chart: Data that is arranged in columns or rows only on a worksheet can be plotted in a doughnut chart. The doughnut chart is similar to a pie chart. Just like a pie chart, a doughnut chart shows the relationship of parts to a whole.

Is there a donut chart in tableau? ›

Tableau is one of the most popular BI and Data Visualization Tools for visualizations/data discovery where you can create a bar chart, line graph, or doughnut chart in Tableau.

Where is doughnut chart widely used? ›

The doughnut chart is generally used to divide a certain field by percentage coverage. It may also be used for numbers instead of percentages, but the sum of all the sections of the doughnut chart will have to be made clear to the viewer.

Which category of graphs need to be avoided donut chart? ›

Expert-Verified Answer. There are some kinds of graphs which must be avoided. Those are – Pie charts, 3D and different tricks, radar graphs, donuts and surface graphs.

What are the disadvantages of donut chart? ›

Donut chart has several disadvantages:

They take up more space than, for example, Bar chart. They are inconvenient for making accurate comparisons between different data sets, since visually the area of segments is more difficult to compare than the length.

What is the goal of donut? ›

The Doughnut consists of two concentric rings: a social foundation, to ensure that no one is left falling short on life's essentials, and an ecological ceiling, to ensure that humanity does not collectively overshoot the planetary boundaries that protect Earth's life-supporting systems.

What chart is better than a pie chart? ›

Percentage Bar Chart

If you want to steer clear of pie charts, and the not too dissimilar donuts, bar charts are a great alternative.

Why do people use pie charts instead of bar graphs? ›

Why is a pie chart preferred to a bar graph? A pie chart is preferred when you have a small data set (less than six categories), and you want to show the percentages of a whole. However, when you want to compare categories of large data sets, bar charts are the right choice.

Why are pie charts the best? ›

Advantages of a Pie Chart

It represents data visually as a fractional part of a whole, which can be an effective communication tool for the even uninformed audience. It enables the audience to see a data comparison at a glance to make an immediate analysis or to understand information quickly.

What is a waffle chart? ›

What Is A Waffle Chart? A waffle chart is essentially a square display made up of 100 smaller squares organized in a 10-by-10 grid where each box corresponds to 1%. The colored boxes represent the percentage of the target that was met, with 100 percent being the entire goal.

What is a good substitute for a pie chart if you have too much data? ›

The first alternative to the pie chart is the stacked bar chart. Stacked bar charts are a much better choice if you have more than 3 variables of data that need to display as a whole.

What are the two most widely used charts? ›

Bar charts and pie charts are very common chart types with some overlap in use cases. In this article, you'll learn more about when to choose each one.

What is the most widely used chart in project management? ›

Gantt charts are undoubtedly the most prominent project management charts that modern businesses and managers use to control their projects. A Gantt chart provides you the timeline view of your projects.

Which graph is best for large data sets? ›

Scatter plots are best for showing distribution in large data sets.

How do you align text in a donut chart? ›

To get the label center in donut chart, Select the 2nd pie chart and go to label, Click on automatic next to alignment. Now click on middle under vertical and change the font size as per requirement. Hope this helps you.

Which of the following is the main difference between pie chart and doughnut chart in MS Excel 2010? ›

It is similar to a Pie Chart with the only difference that a Doughnut Chart can contain more than one data series, whereas, a Pie Chart can contain only one data series.

What is the difference between pie chart and line chart? ›

Line graphs can also be used to compare changes over the same period of time for more than one group. . . . a Pie Chart. Pie charts are best to use when you are trying to compare parts of a whole.

What is the major difference between a pie chart and a column chart? ›

Column chart: for comparing data across categories. Pie Chart: for showing the relative shares of categories in a total. Line Chart: for showing trends in a series over time. Scatter Plot: for showing the relationship between two series (given later).

Why would you use a circle graph instead of a bar graph? ›

Circle graphs are most useful when comparing parts of a whole or total. Bar graphs also make comparisons easily. Unlike most circle graphs, bar graphs compare exact amounts. Circle graphs are used when dealing with percentages, and the percentages of the pieces add up to 100 percent.

Why are pie charts better than bar graphs? ›

Why is a pie chart preferred to a bar graph? A pie chart is preferred when you have a small data set (less than six categories), and you want to show the percentages of a whole. However, when you want to compare categories of large data sets, bar charts are the right choice.

Why is a pie chart better than a line graph? ›

Pie charts to show you how a whole is divided into different parts. You might, for example, want to show how a budget had been spent on different items in a particular year. Line graphs show you how numbers have changed over time.

Which advantage does a Treemap have over a pie or doughnut chart? ›

Tree maps are the only visualizations that can have data labels applied to them. The rectangular blocks of a tree map are easier to read than the wedges of pie and donut charts. Unlike a pie chart, a tree map will always represent 100 percent of all your filtered data.

What is the difference between Treemap and pie chart? ›

The big difference with pie charts is that Treemaps allow you to compare the parts that make up the whole in a scheme of nested rectangles in a relatively small space. An advantage over pie charts is that they can include tens or hundreds of parts in a structure that may or may not be hierarchical.

Why is pie chart better? ›

Advantages of a Pie Chart

It represents data visually as a fractional part of a whole, which can be an effective communication tool for the even uninformed audience. It enables the audience to see a data comparison at a glance to make an immediate analysis or to understand information quickly.

Why is a pie chart the best choice? ›

Pie charts make sense to show a parts-to-whole relationship for categorical or nominal data. The slices in the pie typically represent percentages of the total. With categorical data, the sample is often divided into groups and the responses have a defined order.

When would you use a pie chart instead of a bar graph? ›

Bar charts are recommended to show trends and comparisons; pie charts are recommended when we compare values to a certain entirety. In principle, it is advised against the use of pie charts when we want to show the precise value, or when we want to compare different values.

Why not to use pie charts? ›

The quantities in each category should be easy to estimate and the category labels should be clear. Pies and doughnuts fail because: Quantity is represented by slices; humans aren't particularly good at estimating quantity from angles, which is the skill needed. Matching the labels and the slices can be hard work.

Why do pie charts have a bad reputation? ›

Pie charts are considered bad for visualization as humans can compare length better than angles – making other graphs far more suitable. What most users fail to understand is that pie charts are meant to showcase the part-to-whole relationship between the given data, and not for comparison.


1. How I built this AWESOME donut chart without using custom visuals (Power BI)
(Data Pears)
2. Power BI Visual Guide #12 - The Donut Chart Done Right!
(Jason Davidson)
3. 8.2 How to create Drill-Down Donut Chart in Power BI | Power BI Tutorial for Beginners
(Pavan Lalwani)
4. Power BI Donut Chart | Donut Chart in Power BI
5. Filled Donut Chart in power bi | Drill-Down Donut Chart Power BI Custom Visual | Donut vs pie Chart
6. How to create Donut Chart in Power BI | Difference between Donut Chart & Pie Chart | Power BI
(Information Arjan)


Top Articles
Latest Posts
Article information

Author: The Hon. Margery Christiansen

Last Updated: 08/27/2023

Views: 6717

Rating: 5 / 5 (70 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: The Hon. Margery Christiansen

Birthday: 2000-07-07

Address: 5050 Breitenberg Knoll, New Robert, MI 45409

Phone: +2556892639372

Job: Investor Mining Engineer

Hobby: Sketching, Cosplaying, Glassblowing, Genealogy, Crocheting, Archery, Skateboarding

Introduction: My name is The Hon. Margery Christiansen, I am a bright, adorable, precious, inexpensive, gorgeous, comfortable, happy person who loves writing and wants to share my knowledge and understanding with you.