Power BI Ribbon Chart is useful to quickly identify which categorical data has the highest rank (large values). In this article we will show you, How to Create a Ribbon Chart in Power BI with example.
For this demonstration we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Ribbon Chart in Power BI
In order to create a Ribbon Chart, first Drag and Drop the Sales Amount from Fields section to Canvas region. This will automatically create a Column Chart as we shown in below.
Next, let me add English Country Region Name to Axis section. You can do this by dragging English Country Region Name to Axis section, or simply check mark the English Country Region Name column. This 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 will automatically convert the Clustered Column Chart into Ribbon Chart. From the below screenshot, 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. This will automatically 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 Region Name (By default, it is sorted by Sales Amount). To do this, click on the … (3 dots) on top right corner, and select the Sort By English Country Region Name option as we shown below.
Now you can see the proper Ribbon Chart
Hover over any bar will show you 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 Ribbon Chart
NOTE: I suggest you to refer Format Ribbon Chart article to understand the steps involved in formatting these Ribbons.
Thank You for Visiting Our Blog