In this documentation, we’ll learn how to Create Area Chart in PowerBI. Firstly, we have to understand what is it and when should we use it.
Introduction to Area chart in PowerBI
An area chart displays data points connected by lines, with the area beneath the lines filled in. It visualizes quantitative data over time or other continuous intervals, emphasizing the magnitude of change. Use it to show trends, compare multiple datasets, and highlight the overall volume or total value, such as cumulative sales or resource usage over periods.
Dataset description
The supermarket dataset is used in the project. It contains information about invoice ID, branch, city, customer type, gender, product line, unit price, quantity, tax, total amount, sale date and time, payment mode, COGS, gross margin percentage, gross income, and purchase rating.
You can access the dataset here.
| 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 |
Data Sample:
Procedure to Create Area 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.
Step6: Select Area Chart from Visualizations Section (Right Hand Side).
Step7: Here, we’ll put the following data (from supermarket_sales) in different fields:
| X-axis | Payment |
| Y-axis | Quantity (Sum of Quantity) |
| Legend | Customer type |
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 turn on the data labels.
What the Chart indicating
The area chart in PowerBI shows how many items were sold with different payment ways, showing the contributions from both members and regular users. Overall, the chart shows that credit cards are used for the most payments, with regular users making the most credit card transactions. When it comes to buying, cash and e-wallets are pretty close, with members slightly ahead in both. This chart does a good job of showing how the payment ways are spread out among different types of users.
Conclusion
With an Area Chart, we can view our categorical and numeric data as line with containing area in x-axis and y-axis. There is a functionality of marker (looks like bubble) present the change of variable. We can get the details of each point by moving the cursor over the area visual and show much details using tooltip field.
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.
🔔 Follow Me: LinkedIn| Youtube | Instagram | Twitter
👏 Like for this article and subscribe to our newsletter
📰 View more content on my DataSpoof website
