DataBrighten

    Power BI dashboard practice

    4 questionswith checked answers ยท sample sales data

    Build a one-page sales report: cards, a region bar chart, a margin table and a monthly trend. Updated 3 November 2026.

    textnumberdateyes/no

    Steps

    1. Get data > Excel workbook > sales-orders-1000.xlsx > sales_orders sheet > Load.
    2. New measure: Total Sales = SUM('Sales Orders'[sales]). Then Total Profit = SUM('Sales Orders'[profit]).
    3. New measure: Margin % = DIVIDE([Total Profit], [Total Sales]).
    4. Add two Card visuals (Total Sales, Total Profit), a clustered bar chart of Total Sales by region, and a table of category with Margin %.
    5. Add a line chart with order_date (Month hierarchy) on the axis and Total Sales as the value.
    6. Check your visuals against the answers below.

    Questions

    try first, then open the answer

    What are total sales and total profit?

    Sales $955,613.76, profit $214,946.97

    File: sales-orders-1000

    Which region has the highest sales?

    South, $299,380.41 (Midwest $234,801.89, West $217,262.68, Northeast $204,168.78)

    File: sales-orders-1000

    Profit margin (profit / sales) by category?

    Office Supplies 26.98%; Technology 22.32%; Furniture 21.42%

    File: sales-orders-1000

    Which month had the highest sales?

    2023-02, $69,236.92

    Add a month column (=TEXT(B2,"yyyy-mm") in Excel, or FORMAT in Power BI), then sum sales by it.

    File: sales-orders-1000