Create a Ribbon Chart in Power BI

Power BI Ribbon Chart is useful to quickly identify which categorical data has the highest rank (large values). Let me show you how to Create a Ribbon Chart in Power BI with example.

For this Power BI Ribbon Chart demonstration, we are going to use the SQL Data Source that we created in our previous article. So, Please refer to Connect Power BI to SQL Server article to understand the Power BI Data Source.

How to Create a Ribbon Chart in Power BI

To create a Ribbon Chart in Power BI, first Drag and Drop the Sales Amount from Fields section to the Canvas region. It automatically creates a Column Chart, as we showed in the below screenshot.

Create a Ribbon Chart in Power BI 1

Next, let me add the English Country Region Name to the Axis section. You can do this by dragging Country Region Name to Axis section, or simply checkmark the Country column. It will automatically create a Column Chart for you.

Create a Ribbon Chart in Power BI 2

Next, add Product Color from DimProduct table to the Legend section.

Create a Ribbon Chart in Power BI 3

By clicking the Ribbon Chart under the Visualization section, it will convert the Clustered Column Chart into Ribbon Chart. From the screenshot below, you can see the Ribbon Chart that shows the Sales by Country and Color.

Create a Ribbon Chart in Power BI 4

Create a Ribbon Chart in Power BI Approach 2

First, click on the Ribbon Chart under the Visualization section. It will create a Ribbon Chart with dummy data, as shown in the below screenshot.

Create a Ribbon Chart in Power BI 5

Let me drag the Sales Amount from Fields section to Values field and English Country Region Name from Dim Geography to Axis Field.

Create a Ribbon Chart in Power BI 6

Next, add Product Color to the Legend section.

Create a Ribbon Chart in Power BI 7

Let me sort the data by English Country Name (By default, it is sorted by Sales Amount). To do this, click on the … (3 dots) on the top right corner, and select the Sort By English Country Region Name option as we showed below.

Create a Ribbon Chart in Power BI 8

Now you can see the proper Power BI Ribbon Chart

Create a Ribbon Chart in Power BI 9

Hover over any bar shows the Tool-tip of Country Name, Product Color, and Sales Amount

Create a Ribbon Chart in Power BI 10

Hover over any position in-between the two bars will show you the Tool-tip of Previous Country Sales, Next Country Sales, Difference in percentage, and the Rank between those two countries in this case

Create a Ribbon Chart in Power BI 11

Let me do some quick formatting to this Power BI Ribbon Chart

NOTE: I suggest you refer to the Format Ribbon Chart article to understand the steps involved in formatting these Ribbons, background colors, data labels, etc.

Create a Ribbon Chart in Power BI 12