About this lesson
In this module we will take a look at creating bar and column charts to display our data.
Bar & Column Charts
Working with Bar and Column charts in Power BI.
When to use
Clustered Bar and Column charts are very useful for comparing values to each other, stacked charts are useful for showing buildup and 100% stacked charts are great for showing the portion of a whole.
Bar and Column charts are very similar, essentially just 90 degrees different. (Column charts stand up, bar charts fell over.)
Types of Bar and Column Charts
- 100% Stacked
- Drag your Field into the Axis area. The unique items in this field will be used for the primary axis (bottom for Column, left side for Bar)
- The alternate axis is calculated automatically
- The measure(s) to visualize should be dragged into the Value area
- Legends, tooltips and color saturation can also be configured
- Dragging multiple fields into the Axis area will activate Drill Down
- Dragging multiple fields into the Value area will render stacked or side-by-side depending on the type of chart chosen
- Visual formatting can be done via the fields under the paint roller in the Visualizations area
- Trend lines can be found under the magnifying glass icon in the Visualizations area
Hints & tips
Common Modifications for bar and column charts
- Rename the Legend and force it to bottom
- Provide a custom title for the chart
- Turn on Data Labels and turn off the values axis (y axis for Column Charts, x axis for Bar Charts)
Lesson notes are only available for subscribers.