Power BI Visual Data Quality MVP package - v1.1.0.0 Free

Data Health Panel (Power BI Visual)

A Power BI custom visual that evaluates whether data can be trusted by showing a weighted 0-100 health score, four quality KPI tiles, and a plain-English diagnostic issue list.

Data Health Panel.pbiviz
Screenshot of the Data Health Panel Power BI custom visual showing a score, KPI cards, and issue list

What it does

A clear signal for the health of the data behind the report.

Data Health Panel evaluates selected fields across completeness, freshness, uniqueness, and category validity. It gives teams a concise health score, focused quality indicators, and diagnostic issues without turning the report page into a troubleshooting maze.

Features

Designed to clarify data trust.

Weighted Data Health Score

Computes a 0-100 score from completeness, freshness, uniqueness, and validity using intent-driven Power BI field buckets.

Gives report users a single trust signal before they interpret operational metrics.

Completeness Checks

Measures the average percent of non-blank values across fields selected for completeness.

Makes missing values visible inside the Power BI report instead of hiding quality checks in a separate workflow.

Freshness Evaluation

Compares the latest selected date against fresh and stale hour thresholds.

Helps IT and BI teams see when a Power BI report is relying on stale operational data.

Uniqueness Detection

Calculates distinct-value rates and flags duplicate identifier values, with row limits for distinct-count performance.

Reduces duplicate-driven reporting errors such as double counting cases, tickets, or transactions.

Category Validity Review

Checks category fields for blanks, low-frequency categories, and high fragmentation.

Surfaces operational taxonomy issues that can make filters, slicers, and status dashboards harder to trust.

Plain-English Issue List

Ranks diagnostic messages by severity and links issues to the related quality dimension.

Turns quality scoring into actionable report feedback for analysts, BI developers, and operations teams.

Field buckets

Purpose-built inputs for quality checks.

Score formula: 0.4 * Completeness + 0.25 * Freshness + 0.2 * Uniqueness + 0.15 * Validity

Fields to Check Completeness

Up to 20 fields

Fields where blanks or nulls reduce the completeness score.

Fields to Check Uniqueness

Up to 20 fields

Identifier fields where repeated values reduce the uniqueness score.

Field to Check Freshness

1 date field

A date field used to evaluate how old the dataset is.

Fields to Validate Categories

Up to 20 fields

Category fields checked for blanks, low-frequency values, and fragmentation.

Controls

Quiet controls for report-ready layouts.

Show or hide the health score, KPI tiles, and issue list.
Adjust base font size for report layouts.
Configure fresh hours, stale hours, blank thresholds, low-frequency thresholds, fragmentation thresholds, and row limits.
Override good, warning, and bad score colors.

How to use

Add the visual, map the fields, review the signal.

  1. 1 Import the Data Health Panel .pbiviz package into Power BI Desktop.
  2. 2 Add Data Health Panel to the report canvas.
  3. 3 Assign fields into the intent-driven buckets: completeness, uniqueness, freshness, and category validity.
  4. 4 Tune display, threshold, and color settings from the Power BI formatting pane.
  5. 5 Review the health score, KPI tiles, and diagnostic issue list directly in the report.

Use cases

Built for teams responsible for trusted data.

Data Analysts
BI Developers
IT Operations
Data Governance

Get the visual

Add a trust signal to your report data.

Download the current Data Health Panel package for free. Documentation and Microsoft AppSource slots are prepared for the production release path.