Custom visuals from marketplace in Power BI - Dashboard Guide

Dashboard Mode - Custom visuals from marketplace

Business Question

How can we use custom visuals from the Power BI marketplace to better understand sales trends and customer satisfaction?

Sample Data

Month	Region	Sales	Customer Satisfaction
Jan	North	120	85
Jan	South	150	80
Feb	North	130	88
Feb	South	170	82
Mar	North	140	90
Mar	South	160	85

Dashboard Components

• KPI Card - Total Sales: Shows total sales across all months and regions.
  Formula: Total Sales = SUM(SalesData[Sales])
  Result: 870
• Custom Visual - Radial Gauge (from Marketplace): Displays average customer satisfaction.
  Formula: Avg Satisfaction = AVERAGE(SalesData[Customer Satisfaction])
  Result: 85
• Custom Visual - Heatmap (from Marketplace): Shows sales by Month and Region with color intensity.
  Data: Sales values mapped by Month (rows) and Region (columns)
• Table: Detailed data table showing Month, Region, Sales, and Customer Satisfaction.

Dashboard Layout

+----------------------+-----------------------+
|      KPI Card        |   Radial Gauge Visual  |
|   (Total Sales)      | (Avg Customer Sat.)   |
+----------------------+-----------------------+
|                      Heatmap Visual               |
|                (Sales by Month & Region)          |
+---------------------------------------------------+
|                      Data Table                    |
|          (Month, Region, Sales, Satisfaction)     |
+---------------------------------------------------+
    

Interactivity

The dashboard includes a slicer for Region. When a region is selected:

• The Total Sales KPI updates to show sales only for that region.
• The Radial Gauge updates to show average customer satisfaction for the selected region.
• The Heatmap filters to show sales only for the selected region across months.
• The Data Table shows only rows for the selected region.

Self Check

Add a filter for Region = North. Which components update and what are their new values?

• Total Sales KPI: Updates to 390 (120 + 130 + 140)
• Radial Gauge: Updates to average satisfaction 87.7 ((85 + 88 + 90) / 3)
• Heatmap: Shows sales for North region only by month.
• Data Table: Shows only rows where Region is North.

Key Result

Dashboard showing total sales, average customer satisfaction, and sales heatmap using custom visuals from the Power BI marketplace.