Composite models in Power BI - Dashboard Guide

Dashboard Mode - Composite models

Dashboard Goal

Understand sales performance by combining data from local sales and online sales sources in one dashboard.

Sample Data

Local Sales Data

Store	Month	Sales
Store A	Jan	100
Store B	Jan	150
Store A	Feb	120
Store B	Feb	130
Store A	Mar	140
Store B	Mar	160

Online Sales Data

Region	Month	Sales
East	Jan	200
West	Jan	180
East	Feb	210
West	Feb	190
East	Mar	220
West	Mar	200

Dashboard Components

• KPI Card: Total Local Sales
  Formula: Total Local Sales = SUM('Local Sales'[Sales])
  Result: 800 (100+150+120+130+140+160)
• KPI Card: Total Online Sales
  Formula: Total Online Sales = SUM('Online Sales'[Sales])
  Result: 1200 (200+180+210+190+220+200)
• Bar Chart: Sales by Month (Local vs Online)
  Data: Months on X-axis, Sales on Y-axis, two series: Local Sales and Online Sales
  Formulas:
  Local Sales by Month = SUM('Local Sales'[Sales])
Online Sales by Month = SUM('Online Sales'[Sales])
  Visual shows side-by-side bars for each month comparing local and online sales.
• Table: Detailed Sales Data
  Columns: Store, Region, Month, Sales
  Data combined from both sources using composite model relationships on Month.
  Shows all sales rows from both local and online data.

Dashboard Layout

+----------------------+----------------------+
| Total Local Sales KPI | Total Online Sales KPI|
+----------------------+----------------------+
|                      Bar Chart: Sales by Month                      |
+--------------------------------------------------------------------+
|                          Detailed Sales Data Table                 |
+--------------------------------------------------------------------+

Interactivity

A slicer on Month filters all components simultaneously. Selecting a month updates the KPI cards, bar chart, and table to show sales only for that month from both local and online data.

Another slicer on Store filters only the local sales data components (Total Local Sales KPI, Local Sales bars, and rows in the table with Store info).

A slicer on Region filters only the online sales data components (Total Online Sales KPI, Online Sales bars, and rows in the table with Region info).

Self Check

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

• Total Local Sales KPI: Updates to 250 (120 + 130)
• Total Online Sales KPI: Updates to 400 (210 + 190)
• Bar Chart: Shows bars only for Feb with local sales 250 and online sales 400
• Detailed Sales Data Table: Shows only rows where Month is Feb from both local and online data

Key Result

Dashboard combining local and online sales data to compare total and monthly sales using composite models.