0
0
Power BIbi_tool~8 mins

Parameters in Power BI - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Parameters
Dashboard Goal

Help a sales manager explore sales data by selecting a specific year using a parameter. The dashboard updates key sales numbers and charts based on the chosen year.

Sample Data
YearMonthRegionSales
2022JanNorth100
2022FebSouth150
2023JanNorth200
2023FebSouth250
2024JanNorth300
2024FebSouth350
Dashboard Components
  • Parameter Selector: A dropdown slicer for Year with options 2022, 2023, 2024. User selects one year to filter data.
  • Total Sales KPI Card: Shows total sales for the selected year.
    Formula: Total Sales = CALCULATE(SUM(Sales[Sales]), Sales[Year] = SelectedYear)
    Example: If 2023 selected, total sales = 200 + 250 = 450
  • Monthly Sales Bar Chart: Displays sales by month for the selected year.
    Data filtered by parameter.
    X-axis: Month
    Y-axis: Sales
  • Sales by Region Table: Shows sales totals by region for the selected year.
    Formula: Sales by Region = CALCULATE(SUM(Sales[Sales]), Sales[Year] = SelectedYear)
Dashboard Layout
+----------------------+----------------------+
| Parameter Selector    | Total Sales KPI Card |
+----------------------+----------------------+
|                      Monthly Sales Bar Chart           |
+-------------------------------------------------------+
|                  Sales by Region Table                 |
+-------------------------------------------------------+
Interactivity

The Parameter Selector controls the SelectedYear variable. When the user picks a year, all other components update to show data only for that year.

  • Total Sales KPI recalculates total sales for the chosen year.
  • Monthly Sales Bar Chart filters to show sales by month for the selected year.
  • Sales by Region Table updates to show sales totals by region for the selected year.
Self Check

If you select the year 2024 in the Parameter Selector, what is the total sales shown in the KPI card?

Answer: 300 + 350 = 650

Which months appear in the Monthly Sales Bar Chart?

Answer: Jan and Feb

Which regions appear in the Sales by Region Table?

Answer: North and South

Key Result
Dashboard lets user pick a year parameter to see total sales, monthly sales chart, and sales by region for that year.