Ribbon charts are useful for visualizing how the ranking of categories changes over time or across different categories. They make it easy to identify which category has the highest or lowest rank at different points. It is more like a stacked column chart. Adding a Legend divides the data into categories and displays ribbons that show how the ranking of each category changes across the X-axis using different colors.
How to Proceed?
Step 1
Launch power BI desktop app and open the new report page and import the data required.
Step 2
In “visualizations” pane click on “Ribbon chart” which is highlighted in the given figure.
Step 3
Drag the data fields into “Build visual pane” that you want to analyze.
X-axis: Represents categories -Year
Y-axis: Represents numerical value that you want to display within each category- Participants
Legend: Explain the groups in categories - Continent
Step 4
Customizing the appearance
You can customize the appearance of the visual. You can change Title, Font size, Style, Colors and Data labels. Click anywhere on the visual and set the below properties in the Format section.
Additionally in Ribbon chart we have options to change the color of the ribbons.
This improves clarity and helps viewers easily identify and understand the distinctions between level of ranking in categories
“Reverse order” option allows you to rearrange the order of data series easily.
Connector color: We can also keep the ribbon color off by using option “Connector color”. Also, in this visual we fixed the ribbon transparency to 28%.
Border: To keep border to the ribbons, keep the Border toggle on.
Spacing: It represents the space between the ribbons
In Power BI, Cross filtering feature in ribbon chart allows you to focus on specific data points by interacting with other visuals on the report.
The space between the two bars in ribbon chart represents the change between the last category to current category with rank details in tooltip which makes users understand better
Step 5
Finally, your Ribbon chart is ready. Save the Power BI report to preserve the visual and its formatting.
When to use Ribbon chart?
Ribbon chart can be used when we want to visualize flow between categories with trends along with its ranking. From the chart we can easily identify which data have highest rank
Pros
- It is more powerful in showing flow of data with rank which represent the clear representation of data
- It is well suited for displaying sequential categorical data
- We can compare the categories using this chart
- More interactive and visually appealing
Cons
- Visual become more complex with a large number of categories in data
- Complex ribbon charts with large dataset impact the report performance
Conclusion
The ribbon chart is a valuable visualization tool in Power BI, offers unique advantages to display the flow and relationships between categorical dimensions
Useful Information
| Tags | Power BI |
| Useful links |
|
| MS Learn Modules |
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-ribbon-charts1 |
| Test Your Knowledge | Quiz |
No comments:
Post a Comment