Create ribbon charts in Power BI

APPLIES TO: noPower BI service for consumers yesPower BI service for designers & developers yesPower BI Desktop noRequires Pro or Premium license

Note

These visuals can be created and viewed in both Power BI Desktop and the Power BI service. The steps and illustrations in this article are from Power BI Desktop.

You can create ribbon charts to visualize data, and quickly discover which data category has the highest rank (largest value). Ribbon charts are effective at showing rank change, with the highest range (value) always displayed on top for each time period.

ribbon chart

Note

Sharing your report with a Power BI colleague requires that you both have individual Power BI Pro licenses or that the report is saved in Premium capacity. See sharing reports.

Prerequisites

This tutorial uses the Retail Analysis sample PBIX file.

  1. From the upper left section of the menubar, select File > Open

  2. Find your copy of the Retail Analysis sample PBIX file

  3. Open the Retail Analysis sample PBIX file in report view Screenshot of the report view icon..

  4. Select Screenshot of the yellow tab. to add a new page.

Create a ribbon chart

  1. To create a ribbon chart, select Ribbon chart from the Visualizations panel.

    visualization templates

    Ribbon charts connect a category of data over the visualized time continuum using ribbons, enabling you to see how a given category ranks throughout the span of the chart's x-axis (usually the timeline).

  2. Select fields for Axis, Legend, and Value. In this example, we've selected: Store > OpenDate, Item > Category, and Sales > This year sales > Value.

    selected Fields

    Since the dataset contains data for only one year, we removed the Year and Quarter field from the Axis well.

  3. The ribbon chart shows rank for every month. Notice how rank changes across time. For example, the Home category moves from second to fifth from February to March.

    ribbon chart

Format a ribbon chart

When you create a ribbon chart, you have formatting options available in the Format section of the Visualizations pane. The formatting options for ribbon charts are similar to those for a stacked column chart, with additional formatting options that are specific to the ribbons.

ribbon template on Visualization pane

These formatting options for ribbon charts let you make adjustments.

  • Spacing lets you adjust how much space appears between ribbons. The number is the percentage of the column's maximum height.
  • Match series color allows you to match the color of the ribbons with the series color. When set to off, ribbons are gray.
  • Transparency specifies how transparent the ribbons are, with the default set to 30.
  • Border lets you place a dark border on the top and bottom of the ribbons. By default, borders are off.

Since the ribbon chart does not have y-axis labels, you may want to add data labels. From the Formatting pane, select Data labels.

formatting options for data labels

Set formatting options for your data labels. In this example, we've set the text color to white and display units to thousands.

ribbon template on Visualization pane

Next steps

Scatter charts and bubble charts in Power BI

Visualization types in Power BI