In this article, we will discuss the Doughnut Chart in Power BI.
A doughnut chart is the same as a Pie chart the only difference is that is has a hole in it like a doughnut. It is used to determine the relationship of the part to a whole. The blank space in between can be used to show labels or layers or icons. Want to get more information then check our latest Power BI Training Program and become a master in Visual Storytelling with Power BI.
The following is the example of a Doughnut Visual.
Let us create a Doughnut Chart;
Must Check: Power BI Visualization with Bars & Column
Steps to Create a Doughnut Chart in Power BI
For creating a Doughnut chart, a sample is needed. Here we will use Retail Analysis Sample to create a doughnut chart to display the current year’s sale by category. The sample can be downloaded here.
- Step 1) Open a new report. If you are using Power BI Service open the report in the editing view.
- Step 2) From fields pane, select Sales>Last Year Sales.
- Step 3) To convert the Bar chart in the doughnut chart, select the icon of the Doughnut chart from the visualization pane. If in the values area Last Year’s Sale is not there, drag and drop it in values.
- Step 4) Now, to add a category to the legend area, select Item>Category.
- Step 5) Now we can modify the colors and label accordingly. The best way to do it is to explore the formatting pane by yourselves. You can modify the colors, labels, size, etc.
Must Check: Top 10 Best Power BI Templates for Visualization
Doughnut Chart Editions
Doughnut Charts are Available in two editions namely, Light edition & Full Edition.
The Light edition is available free, while the Full Edition is charged.
Features of Doughnut Chart in Power BI
- You can directly drill down to multiple levels to explore by clicking on the chart.
- Drilling is possible to even the smallest data slices by interactive labels.
- When more than 15 slices are displayed on the chart automatically ‘others’ slice is added.
- Full customization can be done to your doughnut chart.
- Multiple charts like a pie chart, doughnut chart or gauge chat (half doughnut) are possible in full edition.
- It is possible to adjust the visible number of slices; the others can be grouped together.
- Cross filtering is possible. It allows you to filter the dashboard using visuals.
- Cross-chart filtering is possible. Instead of using slices you can select data points from multiple charts.
- You can assign a filter to act as a visual. This act is known as Filter Control.
- You can bookmark your configuration and view later.
- You can drill down your data in detail.
- You can experience faster loading time and smoother animations.
Use of Doughnut Chart
It is advisable to use the Doughnut Chart in Power BI under the following circumstances;
- The qualities that need to be plot should not have negative values.
- The qualities that need to be plot should not have zero value.
- You should possess at least one piece of information that you need to plot.
- You should not possess more than seven information to plot (You can always plot as many s information but the quality of viewing them clearly will decrease).
Do you know the uses of the Bar & Column chart?
In this article, we got to know about the Doughnut chart, when it can be used, how to make one in Power BI and the difference between Light Edition & Full Edition Doughnut Chart. Now let’s check the What is Power BI & its applications.