0
0
Power BIbi_tool~5 mins

Bar and column charts in Power BI - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
Bar and column charts help you compare values across categories visually. They make it easy to see which items are bigger or smaller at a glance.
When you want to compare sales numbers for different products side by side.
When you need to show monthly revenue changes over a year.
When you want to highlight the top performing regions in a report.
When you want to display survey results by category clearly.
When you want to compare expenses across departments.
Steps
Step 1: Click
- Report view canvas
The canvas is active and ready for a new visual
💡 Make sure no other visual is selected to add a new chart
Step 2: Select
- Visualizations pane > Bar chart or Column chart icon
A blank bar or column chart placeholder appears on the canvas
Step 3: Drag
- Fields pane > a categorical field (e.g., Product Name) to Axis well in Visualizations pane
The chart axis updates to show categories from the selected field
Step 4: Drag
- Fields pane > a numeric field (e.g., Sales Amount) to Values well in Visualizations pane
Bars or columns appear representing the sum of the numeric values for each category
Step 5: Resize and move
- Chart on the canvas
The chart fits well in the report layout and is easy to read
Step 6: Click
- Format pane (paint roller icon)
Formatting options appear to customize colors, labels, and axis titles
Step 7: Adjust
- Format pane > Data colors, X-axis, Y-axis, Data labels
The chart looks clearer and matches your report style
Before vs After
Before
Canvas is empty with no visuals
After
A bar or column chart shows categories on the X-axis and numeric values as bars or columns with clear labels
Settings Reference
Data colors
📍 Format pane > Data colors
Change the color of bars or columns to improve visual appeal or match branding
Default: Default colors
X-axis
📍 Format pane > X-axis
Control how category labels appear on the horizontal axis
Default: On with automatic settings
Y-axis
📍 Format pane > Y-axis
Control how numeric values appear on the vertical axis
Default: On with automatic settings
Data labels
📍 Format pane > Data labels
Show or hide numeric values on top of bars or columns for clarity
Default: Off
Common Mistakes
Dragging a numeric field to the Axis well instead of the Values well
The chart will not display meaningful categories and may show unexpected results
Always drag categorical fields to Axis and numeric fields to Values
Not resizing the chart, causing labels to overlap or be cut off
The chart becomes hard to read and looks unprofessional
Resize the chart on the canvas to give enough space for labels and bars
Summary
Bar and column charts visually compare values across categories.
Drag categorical fields to Axis and numeric fields to Values to build the chart.
Use the Format pane to customize colors, labels, and axes for clarity.