In this blog, we’ll learn How to Create Doughnut Chart in PowerBI. Firstly, we must understand what it is and when we should use it.
Introduction to Doughnut chart in PowerBI
Doughnut Chart is a variation of Pie chart, and its shape looks like doughnut. It is used to display multiple data series or emphasize overall composition.
Dataset description
The supermarket sales data contains columns like invoice ID, branch, city, customer type, gender, product line, unit price, quantity, tax, total amount, sale date and time, payment option, COGS, gross margin percentage, gross income, and buy rating in this blog.
You can access the dataset here.
Description: In this dataset, there following features/columns:
| Invoice ID | Unique Identifier for each Invoice |
| Branch | There are four branch Site |
| City | City where transactions occurred |
| Customer Type | Type of Customer – Member or Normal |
| Gender | Gender – Male, Female |
| Product Line | Type of Product |
| Unit Price | Price of a Single Unit of Product |
| Quantity | Total Quantity of Product Sell in a Single Purchase |
| Tax 5% | 5% of Tax on Cost of Goods Sold |
| Total | Total Amount of Items without Tax |
| Date | Date of Sale |
| Time | Time of Sale |
| Payment | Mode of Payment |
| COGS (Cost of Goods Sold) | Total Amount of Items with Tax |
| Gross Margin Percentage | Total Profit in Percentage |
| Gross Income | Total Profit |
| Rating | Raing of the purchase in range of 1-10 |
Sample of Data:
Steps to create a doughnut chart in PowerBI
Step1: Open your PowerBI Desktop on your Device.
Step2: Click on Get Data button in Home Ribbon and select Text/CSV.
Step3: Open Prompt box will be open to select your text or csv file.
Step4: After selection of dataset, It will pop up a window for Load OR Transform Data. Click on Load to use data on PowerBI.
Step5: In the following picture, data has been loaded successfully.
Proceeding to Working Steps:
Step6: Select Doughnut Chart from Visualizations Section (Right Hand Side).
Step7: Here, we’ll put the following data (from supermarket_sales) in different fields:
Legend | Payment |
Values | Quantity (Sum of Quantity) |
Details | Gender |
After that you have to click on format your visual. Go to the General click on turn on visual border and the shadow. In the Visual border make the rounded corner of 15 px. After that Go to Visuals and go to details labels and in label content section select category percent of total.
Insights from the doughnut chart in PowerBI
The doughnut chart shows how much people spend on goods using different payment methods, broken down by gender. Cash is the most common way to pay, and women spend a little more than men (59.51K, 18.43%) than men (52.69K, 16.32%). E-wallets have a balanced split, with men spending 55,12K (17.07%) and women spending 54,87K (16.99%). Men spend the least on credit cards, with 47,27K (14.64%) and 53.5K (16.56%), respectively. This chart shows that both men and women like Cash and Ewallet, but Cash is slightly more common overall. Credit cards are the least popular method.
Conclusion
With doughnut charts, we can visualize the proportional distribution of categorical data as segments of a circular ring, where each segment represents a part of the whole. Similar to a pie chart, the size of each section is proportional to its contribution to the total, but with a central hole, making it easier to compare multiple sets of data if layered.
If you like this blog, you can share it with your friends or colleague. You can connect with me on social media profiles like LinkedIn, Twitter, and Instagram.
- 👏 Like for this article and subscribe to our newsletter
- 📰 View more content on my DataSpoof website
- 🔔 Follow Me: LinkedIn| Youtube | Instagram | Twitter
