Column Chart

Step 1: Import Data

• Open Power BI Desktop

• Click Get Data -> Excel/CSV

• Select your dataset

• Click Load

Step 2: Card Visual

• Select Card Visual

• Drag Order ID into fields

• Change aggregation to Count

• Rename title as Order Volume

Step 3: Card Visual

• Select Card Visual

• Drag sell into field

• Change aggregation to Sum

• Format as Currency

• Rename title as Revenue
  

Step 4: Card Visual

• Select Card Visual

• Drag sell into field

• Change aggregation to Average

• Format as Currency

• Rename title as AOV

Step 4: Clustered Column Chart

• Select Clustered Column Chart

• Drag Date into X-Axis

• Drag sell into Y-Axis -> aggregation to Sum

• Rename chart title as Revenue by Month

Step 6: Dashboard

• Add a Text Box

• Type -> 2023 sales Dashboard

• Place the 3 Cards at the top

• Place the column chart below the cards

• Adjust font size and alignment