Theme Auditor
Visual Formatting Consistency Audit
Overview
Features
Prompts
Help
Key Features
Over a few months a report quietly drifts away from its theme. One developer types a hex code straight onto a chart, someone else nudges a font size by hand, a third locks a background to white. None of it throws an error, and none of it follows along when you switch themes — so when a client asks for a rebrand or a designer opens the file, the overrides are scattered across dozens of visuals with no map of where they are. This skill checks every visual, sorts each formatting property into hardcoded vs theme-driven, and gives you a report listing exactly what's been overridden, what the theme actually specifies, and what to set it back 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

Best Practice Analysis
Analyze
Take a Tabular Editor BPA export and get back a ranked report

Bookmark Analysis
Analyze
Simulate bookmark navigation, detect visual leaks, and fix show/hide issues across bookmark chains.

Measure Killer Analysis
Analyze
Identify unused measures, DAX complexity issues, and dependency health across your entire model.

Pbip Analysis
Analyze
Check your star schema, relationships, DAX, Power Query, naming, and security all at once
Tool Information
Skill
39 USD
Bundle (All skills)
249 USD
Category
Analyze
Version
Version 1.2.2.2
or log in if you already have an account

