Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

Basic Power BI Charts

Basic charts help users understand business data by converting numbers into visual representations. Power BI provides column charts, bar charts, line charts, and other visuals to compare values, identify trends, and communicate results clearly.

Learning Objectives

  • Understand the purpose of basic Power BI charts.
  • Identify the difference between bar, column, and line charts.
  • Choose suitable fields for chart axes and values.
  • Create and format a chart in Power BI Desktop.
  • Interpret a chart and avoid common visualization mistakes.

1. What Is a Chart?

A chart is a visual representation of data. Instead of reading many rows in a table, users can compare categories, observe changes over time, and identify patterns through a visual.

Example: Monthly Sales

Jan Feb Mar Apr 15K 21K 27K 34K Sales Month

This example shows monthly sales increasing from January to April. A column chart makes the difference between monthly values easy to see.

2. Common Basic Charts

Chart Type Best Used For Example
Clustered Column Chart Comparing values across categories Sales by month
Clustered Bar Chart Comparing categories with horizontal bars Sales by product
Line Chart Showing trends over time Monthly revenue trend
Stacked Column Chart Comparing totals and their components Sales by month and region
Area Chart Showing trends with emphasis on magnitude Revenue over time

3. Clustered Column Chart

A clustered column chart displays vertical bars for categories. The height of each bar represents the value associated with that category.

Column Chart Structure

Product A Product B Product C Sales Amount Product Category

How to Create a Column Chart

  1. Open your report in Power BI Desktop.
  2. Select an empty area on the report canvas.
  3. Choose the Clustered Column Chart from the Visualizations pane.
  4. Drag a category field, such as Month or Product, to the X-axis.
  5. Drag a numeric field, such as Sales Amount, to the Y-axis or Values field well.
  6. Check the aggregation and confirm that the chart displays the expected result.
Tip: Use a column chart when category labels fit comfortably along the horizontal axis and vertical comparisons are easy to read.

4. Clustered Bar Chart

A clustered bar chart displays horizontal bars. It is especially useful when category names are long or when you want to rank products, employees, or regions by a numeric value.

Sales by Product

Product A Product B Product C Product D 27,000 36,000 21,000 31,000 Sales Amount

When Should You Use a Bar Chart?

  • When comparing many categories.
  • When category names are long.
  • When presenting a product or region ranking.
  • When users need to compare the length of horizontal bars.

5. Line Chart

A line chart connects data points to show how a measure changes across an ordered sequence, such as dates or months. It is commonly used for revenue trends, customer growth, and performance monitoring.

Monthly Revenue Trend

Jan Feb Mar Apr Revenue Month

The line rises from January to February, dips slightly in March, and rises again in April. This makes changes over time easy to identify.

Important: For time-based analysis, use a properly sorted date or month field. If month names are sorted alphabetically, the chart may display an incorrect chronological order.

6. Stacked Column Chart

A stacked column chart divides each column into segments. Each segment represents part of the total, allowing users to compare both overall values and the contribution of categories such as regions or departments.

Sales by Month and Region

Jan Feb Mar North South

A stacked chart is useful when you need to see the total and how its components contribute to that total. If the main goal is to compare individual segments precisely, a clustered chart may be easier to read.

7. Understand Chart Field Wells

The field wells available in Power BI depend on the selected visual and the current version of Power BI Desktop. Common roles include category, value, legend, and tooltips.

Field Role Purpose Example
X-axis Defines categories or horizontal positions Month
Y-axis / Values Defines the numeric measure being plotted Sales Amount
Legend Splits data into series or groups Region
Tooltips Displays additional details when hovering Order Count

How Data Becomes a Chart

Data Fields Month Sales Amount Field Wells Axis Values Chart

8. Aggregation and Chart Accuracy

When a numeric column is added to a chart, Power BI may summarize it using Sum, Average, Minimum, Maximum, or another available aggregation. The correct choice depends on what the data represents.

  • Sum: Adds values, such as total sales.
  • Average: Calculates the arithmetic mean, such as average order value.
  • Count: Counts non-empty values.
  • Minimum: Finds the smallest value.
  • Maximum: Finds the largest value.
Check your results: Counting sales rows is not the same as calculating total sales. Confirm the aggregation and data type before interpreting a visual.

9. Formatting a Basic Chart

Good formatting makes a chart easier to understand without distracting the reader. Select the chart and use the Format visual options available in your Power BI Desktop version.

  1. Add a clear and meaningful chart title.
  2. Use readable axis titles and category labels.
  3. Choose colors that make categories easy to distinguish.
  4. Display data labels when they improve readability.
  5. Use appropriate number formats, such as currency or whole numbers.
  6. Keep gridlines subtle and remove unnecessary visual elements.
Design principle: The chart should make the business message easier to understand. Avoid unnecessary colors, excessive labels, and decorative effects that compete with the data.

10. Practice Activity

Scenario: Retail Sales Analysis

Use the following sample data to build three visuals.

Month Product Region Sales Amount
January Laptop North 25,000
January Phone South 18,000
February Laptop North 30,000
February Phone South 22,000
March Laptop North 34,000
March Phone South 26,000

Tasks

  1. Create a column chart showing total sales by month.
  2. Create a bar chart comparing sales by product.
  3. Create a line chart showing the monthly sales trend.
  4. Add Region to the Legend field of a suitable chart.
  5. Format sales values consistently and give each visual a meaningful title.

11. Knowledge Check

Question 1: Which chart is generally suitable for showing a trend over time?

A. Line chart

B. Card

C. Table only

Question 2: Which chart is useful when category labels are long?

A. Clustered bar chart

B. Line chart only

C. Gauge only

Question 3: What should you verify when a numeric field is added to a chart?

A. The aggregation and data type

B. Only the background color

C. Only the report page name

Show Answers
  1. Question 1: A — Line chart.
  2. Question 2: A — Clustered bar chart.
  3. Question 3: A — The aggregation and data type.

Summary

  • Column charts compare values across categories.
  • Bar charts are useful for comparing categories with horizontal bars.
  • Line charts show trends across an ordered sequence, such as time.
  • Stacked charts show totals and the contributions of their components.
  • Field wells determine how data is represented in a visual.
  • Always verify aggregation, sorting, labels, and number formats.
  • Clear formatting helps users interpret charts correctly.