MIN and MAX in Power BI - Dashboard Guide

Dashboard Mode - MIN and MAX

Business Question

What are the minimum and maximum sales amounts recorded in our sales data?

Sample Data

Order ID	Product	Sales Amount	Region
1001	Chair	150	East
1002	Desk	300	West
1003	Lamp	75	East
1004	Table	450	North
1005	Shelf	200	South

Dashboard Components

• KPI Card: Minimum Sales
  Measure formula: Min Sales = MIN('Sales'[Sales Amount])
  Result: 75
• KPI Card: Maximum Sales
  Measure formula: Max Sales = MAX('Sales'[Sales Amount])
  Result: 450
• Bar Chart: Sales Amount by Product
  X-axis: Product
  Y-axis: Sales Amount
  Shows sales values for each product
• Table: Sales Details
  Columns: Order ID, Product, Sales Amount, Region
  Shows all sales records

Dashboard Layout

+----------------------+----------------------+
|  Min Sales (KPI)     |  Max Sales (KPI)     |
|       [  75  ]       |       [ 450  ]       |
+----------------------+----------------------+
|                      Bar Chart: Sales Amount by Product           |
|                      (Product on X-axis, Sales Amount on Y-axis)  |
+-------------------------------------------------------------------+
|                          Table: Sales Details                      |
+-------------------------------------------------------------------+
  

Interactivity

Adding a filter for Region will update all components:

• The Min Sales and Max Sales KPI cards will recalculate based on the filtered sales amounts.
• The bar chart will show sales amounts only for products sold in the selected region.
• The sales details table will list only the orders from the selected region.

This helps focus on sales performance in specific regions.

Self Check

If you add a filter for Region = East, which components update and what are their new values?

• Min Sales KPI: Updates to 75 (Lamp sale)
• Max Sales KPI: Updates to 150 (Chair sale)
• Bar Chart: Shows only Chair and Lamp sales
• Sales Details Table: Shows only orders 1001 and 1003

Key Result

Dashboard shows minimum and maximum sales amounts with product sales bar chart and detailed sales table.