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.
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.
Next, add Product Color from DimProduct table to the Legend section.
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 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.
Let me drag the Sales Amount from Fields section to Values field and English Country Region Name from Dim Geography to Axis Field.
Next, add Product Color to the Legend section.
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.
Now you can see the proper Power BI Ribbon Chart
Hover over any bar shows the Tool-tip of Country Name, Product Color, and Sales Amount
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
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.