How to create a Ribbon Chart in PowerBI

In this blog, we’ll learn about how to Create Ribbon Chart in PowerBI. Firstly, we have to understand what is it and when should we use it.

Ribbon Chart looks like column charts until you add legend. It specifies that the topmost data point is larger and the bottommost data point is smaller and between the two, other data points rank with their position from top to bottom.

Table of Contents

Dataset description

In this blog, we’ll use a supermarket sales dataset that includes order ID, branch, city, customer type, gender, product line, unit price, quantity, tax, total amount, sale date and time, payment method, cost of goods sold (COGS), gross margin percentage, gross income, and buy rating.

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 ribbon 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 Ribbon 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 ribbon chart in PowerBI compares the number of items bought by normal people and members using different payment methods. The total amount of money bought with Cash and Ewallet is about the same. Normal users are slightly ahead with Cash (1011 units), while members are ahead with Ewallet (1002 units). On the other hand, credit cards are mostly used by members, who bought 1002 units compared to 720 units by regular users, making it the least preferred way overall.

Conclusion

Ribbon Chart in PowerBI can visualize our categorical and numeric data with ribbons that represent the changes over time or categories. In a Ribbon Chart, the x-axis typically represents the categories, while the y-axis represents the numeric values. Now we know that the topmost data point is larger, and the bottommost data point is smaller and between the two, other data points rank with their position from top to bottom.

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.