Web data import in Power BI - Dashboard Guide

Dashboard Mode - Web data import

Business Question

How can we import sales data from a web page into Power BI to analyze monthly sales trends?

Sample Data

Month	Sales
January	1200
February	1500
March	1700
April	1600
May	1800
June	2000

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM('SalesData'[Sales])
  Result: 9800
• Line Chart: Monthly Sales Trend
  X-axis: Month
  Y-axis: Sales
  Shows sales increasing over months.
• Table: Sales Data Table
  Shows raw data imported from the web with columns Month and Sales.

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |      Line Chart      |
|   Total Sales: 9800  |  Monthly Sales Trend |
+----------------------+----------------------+
|               Sales Data Table              |
+---------------------------------------------+

Interactivity

A slicer for Month allows filtering the line chart and table to show sales for selected months only. The KPI card updates total sales accordingly.

Self Check

If you add a filter to show only months from March to June, which components update and what is the new total sales?

Answer: The KPI card, line chart, and table update. The new total sales is 1700 + 1600 + 1800 + 2000 = 7100.

Key Result

Dashboard showing total sales and monthly sales trend from web-imported data with interactive month filter.