Theme Auditor

Back

Visual Formatting Consistency Audit

Analyze

Overview

Features

Prompts

Help

Key Features

A report built over several months accumulates invisible drift — one developer hardcodes a hex color, another manually sets a font size, a third locks a background to white. None of it raises an error in Power BI Desktop, and none of it updates when you change the theme. By the time a client requests a rebrand or a designer reviews the file, overrides are scattered across dozens of visuals with no record of where they are. This skill scans every visual, classifies every formatting property as hardcoded vs theme-driven, and delivers a report telling you exactly what is overridden, what the theme actually specifies, and what to change it to — run it with /theme-auditor.

How it works

Type /theme-auditor, answer two quick questions, and the skill handles everything:

Scans the report — detects the active theme, enumerates all pages and visuals, and estimates the scope of overrides before committing to a full run
Asks two questions: which pages to include (visible only, or with hidden/tooltip pages) and audit depth (full, colors only, or structural only)
Audits every visual — extracts all structural formatting properties, classifies each as Literal (hardcoded) vs ThemeDataColor (theme-driven) vs Absent (inherits theme default)
Suggests the correct theme value for every deviation — font deviations show the matching textClass target, color deviations show the nearest semantic color name
Generates three output files with consistent naming

What you get

Full report (.md) — all deviations grouped by category with the theme's expected value in every row
Compact report (.md) — up to 5 deviations per category with overflow counts, ready for stakeholder review
Structured data (.json) — all deviations, theme spec, and summary for automation

All files follow consistent naming: {project}_theme_audit_{date}_{time}.md

Every report includes six sections:

Report Overview — pages scanned, visuals checked, deviation rate
Deviation Summary — by category with hardcoded vs theme-driven counts
Deviations by Page — visual count and deviation count per page
Theme Specification — the active theme's textClasses (callout, title, header, label) and semantic colors (foreground, background, tableAccent, good/neutral/bad)
Detailed Findings — per deviation: page, visual type, visual ID, property path, hardcoded value, theme default
Theme Palette — full color palette with ColorId index

Explore more in this category