Explanation

A Dynamic Dashboard changes automatically when users change selections or source data.

Dashboard Components

  • KPI cards
  • Dynamic tables
  • Dynamic formulas
  • Charts
  • Drop-down selections
  • Slicers where appropriate
  • Conditional Formatting

Example KPIs

Total Sales

=SUM(SalesData[Sales])

Number of Orders

=COUNTA(SalesData[Order ID])

Unique Cities

=COUNTA(UNIQUE(SalesData[City]))

Dynamic Chart Source

A chart can be connected to a dynamic result generated by formulas such as FILTER, SORT, or UNIQUE.

Practice

Create a dashboard where selecting a city changes the displayed sales records and analysis.

PreviousNext