How to use Power bi ribbon chart

In this power bi tutorial, we will learn about the power bi ribbon chart. And also we will discuss the below points:

  • Power bi ribbon chart
  • Format power bi ribbon chart
  • Power bi ribbon chart y axis
  • Power bi ribbon chart total
  • Power bi ribbon chart sorting
  • Power bi ribbon chart percentage
  • Power bi ribbon chart tooltip
  • Power bi ribbon chart horizontal

Introduction to power bi ribbon chart

  • In power bi we can create ribbon chart to visualize data, and quickly discover which data category has the highest rank.
  • Power bi ribbon chart are effective at showing rank change, with the highest range/value alaways displayed on top for each time period.

Power bi ribbon chart

Here we will see how to create a power bi ribbon chart in power bi desktop.

  • Open your power bi desktop. Load the data using get data.
  • Select the ribbon chart from the visualization pane.
  • In the Axis field, drag and drop date(month) from the field pane.
  • In the legend field, drag and drop category from the field pane.
  • In the value field, drag and drop sales from the field pane.
Power bi ribbon chart
Power bi ribbon chart

In the below screenshot, you can see the power bi ribbon chart.

Power bi ribbon chart
Power bi ribbon chart

Read Power BI Q&A – How to use with examples

Format Power bi ribbon chart

Here we will see the format power bi ribbon chart in the power bi desktop.

For the ribbon chart, the formatting option is similar to those for a stacked column chart with an additional formatting option.

When you create a power bi ribbon chart, formatting options are available in the format section of the visualization pane

Format power bi ribbon chart
Format power bi ribbon chart

General setting

  • In the general section, you can change the X & Y position, width and height of a ribbon chart.
Format power bi ribbon chart
Format power bi ribbon chart

Ribbon chart legend

  • To enable the legend, please select the legend region and toggle the option from off to on.
  • You can change the legend title, position, color, font family, and text size.
Format power bi ribbon chart
Format power bi ribbon chart

Ribbons setting

  • Spacing : Here you can adjust how much space appears between ribbons. And the number is the percentage of the column’s maximum height.
  • Match series color: This feature allows you to match the color of the ribbon with the series of color. When it is off, ribbon are gray.
  • Transparency: this feature specifies you how transparent the power bi ribbon are, with the default set to 30.
  • Border: by using this feature, you place a dark border on the top and bottom of ribbon. By default it is off.
Format power bi ribbon chart
Format power bi ribbon chart

Data label

  • By toggling on the data labels, you can see the data labels in your power bi ribbon chart.
  • By expanding you can change the data label color, display units, orientation, position, over flow text, and text size,
Format power bi ribbon chart
Format power bi ribbon chart

Read Power BI Slicer – How to use with examples

Power bi ribbon chart y axis

Here we will see a power bi ribbon chart y-axis.

The power bi ribbon chart has no y-axis formatting option and in the visualization, it does not show the Y-axis label.

Still, you want to show the y-axis in the ribbon chart, you can use the zoom slider feature to show the y-axis.

In the visualization pane, go to the formatting section, expand the zoom slider (used to easily examine the smaller range of data in a chart) -> turn on the Y-axis and Slider labels.

Power bi ribbon chart y axis
Power bi ribbon chart y axis

In the below screenshot you can see the power bi ribbon chart y-axis.

Power bi ribbon chart y axis
Power bi ribbon chart y axis

Power bi ribbon chart total

Here we will see the power bi ribbon chart total in power bi desktop using sample data.

We will filter the year, to show the total of each month in a year.

  • In the power bi desktop, select the ribbon chart from the visualization pane.
  • In the Axis field, drag and drop date(year and month) from the field pane.
  • In the legend field, drag and drop category from the field pane.
  • In the value field, drag and drop sales from the field pane.
Power bi ribbon chart total
Power bi ribbon chart total
  • In the filter pane, under filter on this visual, expand the order date(year).
  • Select a year, you want to see the total per month.
Power bi ribbon chart total
Power bi ribbon chart total

In the below screenshot you can see the power bi ribbon chart total

Power bi ribbon chart total
Power bi ribbon chart total

Read Power BI Filter vs Slicer

Power bi ribbon chart sorting

Here we will see power bi ribbon chart sorting in power bi desktop using sample data

We will sort the power bi ribbon chart by month of year from left to right.

  • In power bi desktop, select the ribbon chart from the visualization
  • In the Axis field, drag and drop date(month) from the field pane.
  • In the legend field, drag and drop category from the field pane.
  • In the value field, drag and drop sales from the field pane.
Power bi ribbon chart sorting
Power bi ribbon chart sorting
  • Now click on the more icon(…) on the top of the visual.
  • Then select sort by, and select month.
  • Then select sort descending to sort the month from left to right.
Power bi ribbon chart sorting
Power bi ribbon chart sorting

In the below screenshot, you can Power bi ribbon chart sorting.

Power bi ribbon chart sorting
Power bi ribbon chart sorting

Power bi ribbon chart percentage

Here we will see the power bi ribbon chart percentage.

  • In power bi desktop, select the ribbon chart from the visualization.
  • In the Axis field, drag and drop date(month) from the field pane.
  • In the legend field, drag and drop category from the field pane.
  • In the value field, drag and drop profit from the field pane.
Power bi ribbon chart percentage
Power bi ribbon chart percentage
  • Go to format section, under visualization pane. Then turn on data label.
Power bi ribbon chart percentage
Power bi ribbon chart percentage
  • In the field pane click on the profit column, which will open the column tools.
  • In formating section, change the format to percentage
Power bi ribbon chart percentage
Power bi ribbon chart percentage

In the below screenshot, you can see the power bi ribbon chart percentage.

Power bi ribbon chart percentage
Power bi ribbon chart percentage

Read How to use Power bi maps – Complete tutorial

Power bi ribbon chart tooltip

Here we will see the power bi ribbon chart tooltip.

  • In power bi desktop, select the ribbon chart from the visualization.
  • In the Axis field, drag and drop date(month) from the field pane.
  • In the legend field, drag and drop category from the field pane.
  • In the value field, drag and drop sales from the field pane.
  • In the tooltip field, drag and drop profit from the field pane.
Power bi ribbon chart tooltip
Power bi ribbon chart tooltip
  • In the ribbon chart, when you hover your cursor over the connective ribbon part.
  • It display tooltip on the ribbon chart that has previous bar total, the next total and change in position of hover between the two totals.
  • In the below screenshot you can see power bi ribbon chart tooltip.
Power bi ribbon chart tooltip
Power bi ribbon chart tooltip

Power bi ribbon chart horizontal

Here we will see the power bi ribbon chart horizontal.

  • In the power bi desktop, select the power bi ribbon chart from the visualization.
  • In the Axis field, drag and drop date(month) from the field pane.
  • In the legend field, drag and drop category from the field pane.
  • In the value field, drag and drop sales from the field pane.
Power bi ribbon chart horizontal
Power bi ribbon chart horizontal
  • In the format pane you can format the horizontal axis and X-axis color, text size, font style, maximum category width, minimum size, and concatenate label.
  • If you toggle off the X-axis section, then X-axis remove from the visualization.
Power bi ribbon chart horizontal
Power bi ribbon chart horizontal
  • In the below screenshot you can see power bi ribbon chart horizontal.
Power bi ribbon chart horizontal
Power bi ribbon chart horizontal

You may like the following Power BI tutorials:

In this tutorial, we discussed the power bi ribbon chart. And also we discussed the below points:

  • Power bi ribbon chart
  • Format power bi ribbon chart
  • Power bi ribbon chart y axis
  • Power bi ribbon chart total
  • Power bi ribbon chart sorting
  • Power bi ribbon chart percentage
  • Power bi ribbon chart tooltip
  • Power bi ribbon chart horizontal
>