KPI Card and Power Query Editor

Step 1: Load the Dataset

• Open Power BI Desktop

• Click Get Data

• Import the dataset

• Click Load

Step 2: KPI Card

• Select KPI Card

• Drag Order ID -> Value -> Count

• Drag Date -> Trend Axis -> Day

• Drag Order ID -> Target -> Count

• Rename title Order Day Count

Power Query Editor

Power Query Editor is a data transformation and data cleaning tool in Power BI. It is used to clean, modify, filter, and prepare data before creating reports and dashboards.

Main Components of Power Query Editor

• Ribbon Panel

• Queries Pane(Left Side)

• Data Preview Area(Center)

• Query Settings Pane(Right Side)

• Formula Bar

• Column Headers

• Status Bar