In this blog, we’ll learn How to Create Card and Multi-row Card in PowerBI. Firstly, we must understand what it is and when we should use it.
Introduction to Card in PowerBI
- Card is best way to represent single data like total sales, total profit, etc.
- Multi-row Card is a variation of Card and can display multi data in it.
Dataset description
We’ll utilize a supermarket sales dataset with 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 tutorial. This dataset provides complete sales information, making it excellent for creating card in PowerBI.
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 Card and Multi-row Card 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 Card from Visualizations Section (Right Hand Side).
Step7: Here, we’ll put the following data (from Sale) in different fields:
Fields | Total Sale (Sum of Total Sale) |
How to Create a Multi-row Card
Step6: Select Multi-row Card from Visualizations Section (Right Hand Side).
Step7: Here, we’ll put the following data (from Sales) in different fields:
Fields | Total Sale (Sum of Total Sale) |
Total Profit (Sum of Profit) | |
Target Sale (Sum of Target Sale) | |
Quantity (Sum of Quantity) | |
Date 🡪Month |
What the Chart indicating:
Simple card shows that we are visualizing the sum of total sales and that is 25K from dataset.
The multi-row card shows how key measures change from month to month, such as between May and June. It shows the total amount sold, the earnings, the goal sales, and the number of items sold each month. This makes it easy to see how monthly performance compares to goals, showing how well sales and profits match up with them and how the amount sold changes from month to month for useful information.
Conclusion
With a card, we can view key numerical metrics or summarized data in a simple, straightforward way. A card typically displays a single, prominent number along with a label.
With multi-row cards, we can visualize multiple key metrics or summarized data points in a compact and organized format. A multi-row card displays multiple numbers and their corresponding labels in a series of rows.
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
