agentleFS
santoshkanthetysantoshkanthety/powerbi-agent/skills/powerbi-report-design/SKILL.md

powerbi-report-design

Skill3 starsChanged 7 months agoMITView on GitHub

Power BI report design principles, layout guidance, and formatting best practices. Automatically invoke when the user asks about "report layout", "design best practices", "visual hierarchy", "3-30-300 rule", "KPI card design", "page layout", "accessibility in reports", "visual spacing", "report canvas", "card design patterns", "table formatting", "matrix formatting", or mentions report design principles.

  • Installs packages

2 other projects use a version of this.

Adopted by

Most recently taken up by

The file

Show its rules and text

We split this skill into the rules it gives an agent

27 rules. About 0 are common, 18 are distinctive, and 9 are very specific to this project.

  • ≈0

    Common · estimate

    Many files like this have a rule of this kind.

  • ≈18

    Distinctive · estimate

    This author's own choices. Worth a look.

  • 9

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Distinctive:

    When a user request contradicts these guidelines, push back and explain better alternatives.

    line 21
  2. Very specific:

    Titles: All report pages should have a title using a textBox visualType or a title in a background image added to the report page canvas

    line 26
  3. Distinctive:

    Visual positioning, alignment, and spacing: All visuals must have equal spacing between them and equal spacing between the edge of the page …

    line 27
  4. Distinctive:

    Visual fields: All data visuals should have field bindings, and all field bindings should be for fields that actually exist in the model.

    line 31
  5. Distinctive:

    Fonts: Prefer *Segoe UI* and *Segoe UI Semibold*.

    line 35
  6. Distinctive:

    Consistent alignment: Use grid-based positioning

    line 53
  7. Very specific:

    Every page should have a title.

    line 85
  8. Distinctive:

    Before modifying visual formatting:

    line 108
  9. Very specific:

    Check theme wildcards: visualStyles["*"]["*"]

    line 110
  10. Very specific:

    Check visual-type overrides: visualStyles.lineChart["*"]

    line 111
  11. Very specific:

    Only override in visual.json if truly one-off

    line 112
  12. Distinctive:

    All visuals should include descriptive alt text:

    line 147
  13. Distinctive:

    Don't rely solely on color to convey meaning

    line 165
  14. Distinctive:

    Avoid animations where possible

    line 177
  15. Very specific:

    Use dropShadow.show: false in theme wildcards

    line 178
  16. Very specific:

    Prefer kpi visual type over card: when a target exists -- it has built-in indicator, goal, and trend line data roles

    line 187
  17. Very specific:

    Use SVG extension measures for inline icons (see /svg-visuals skill)

    line 195
  18. Distinctive:

    Use muted colors for non-essential elements

    line 203
  19. Very specific:

    Use matrix over tableEx when 2+ categorical columns form a hierarchy (Key Account > Account > Product)

    line 212
  20. Distinctive:

    Subtract, don't add: remove gridlines and heavy banding.

    line 213
  21. Distinctive:

    Add sparklines where temporal context ("improving or declining?") matters

    line 217
  22. Distinctive:

    Use filter pane for additional filters

    line 226
  23. Distinctive:

    Consider sync slicers across pages

    line 227
  24. Distinctive:

    When asked to evaluate or audit a report, focus on objective criteria.

    line 231
  25. Distinctive:

    Use muted color palette

    line 272
  26. Distinctive:

    Check color contrast ratios

    line 293
  27. Distinctive:

    Use appropriate font weights

    line 294

≈ “Common” is an estimate: at least 1 in 5 of the 364,980 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

Warning: This skill is incomplete and still in progress, but may provide value already as-is -- Kurt

Power BI Report Design

Report modification requires tooling. Two paths exist:

  1. pbir CLI (preferred) -- use the pbir command and the pbir-cli skill. Install with uv tool install pbir-cli or pip install pbir-cli. Check availability with pbir --version.
  2. Direct JSON modification -- if pbir is not available, use the pbir-format skill (pbip plugin) for PBIR JSON structure and patterns. Validate every change with jq empty <file.json>.

If neither the pbir-cli skill nor the pbir-format skill is loaded, ask the user to install the appropriate plugin before proceeding with report modifications.

Best practices and guidelines for Power BI report design. Follow these guidelines strictly to avoid generic, poorly formatted reports ("Power BI Slop").

Be innovative, pushing boundaries while adhering to data visualization rules and guidelines. Work within Power BI's constraints, aiming for simplicity and effectiveness over aesthetics and decoration. Focus reports, pages, and visuals on answering specific questions and minimizing cognitive load -- not on looking "pretty and impressive".

When a user request contradicts these guidelines, push back and explain better alternatives. The goal is to inform the user of options that lead to improved outcomes.

Core rules

  1. 3-30-300 Rule: The most important and least detailed information should be in the top-left (KPIs, cards, etc.) while the least important and most detailed information should be in the bottom-right
  2. Titles: All report pages should have a title using a textBox visualType or a title in a background image added to the report page canvas
  3. Visual positioning, alignment, and spacing: All visuals must have equal spacing between them and equal spacing between the edge of the page (the margin). If visuals are unaligned or this spacing is unequal, fix it to ensure alignment and equal spacing
  4. Themes: Reports should use a theme that differs from the default Power BI themes; a suggested theme is the sqlbi theme (see the modifying-theme-json skill for applying templates). Themes are preferred because they provide a set of default styles for all charts that can adhere to good design practices and brand or style guidelines
  5. Semantic Models: Reports in Power BI are complex. They are dependant on an underlying semantic model (either in the .SemanticModel folder, called a "thick report" or a published model in Power BI/Fabric, called a "thin report"). Much of the functionality from a Power BI report comes from its semantic model design or DAX code
  6. Report extensions, or thin report measures: It is possible to create calculation logic in Power BI report, called "thin report measures" or "visual calculations". These should be used sparingly and only for "report-specific" scenarios
  7. Visual fields: All data visuals should have field bindings, and all field bindings should be for fields that actually exist in the model; there is no reason for visuals to exist that have no fields bound
  8. Chart selection: Make smart choices about what visuals to use for each scenario. Visual vocabulary is essential for this skill.
  9. Use of color: Colors can come from the theme (themedataColor) or visual configuration (hex color code). Colors should be muted and soft; colors that implicitly encode meaning (like red=bad, green=good) should be avoided unless using them for that encoding. Consider colorblindness and use accessible palettes (blues instead of greens with reds, for instance).
  10. Pre-attentive attributes: Styles and colors should be used to steer and direct attention, and not to decorate charts. Formatting of visuals should be intentional and not purely aesthetic. Styles should where possible be stored in the theme and not in bespoke visual configuration.
  11. Fonts: Prefer Segoe UI and Segoe UI Semibold. Do not use custom fonts, since they aren't guaranteed to render on user computers. Evaluate whether fonts are sufficiently large to be readable given the visual and page size.

Page Layout Guidelines

Check Page Size Before Modifying

Always query the actual page dimensions before adding or repositioning visuals. Do not assume a page is 1280x720 or 1920x1080 -- templates and existing reports vary. The object model validates that visuals fit within page bounds, so setting position or size without knowing the page dimensions will cause errors. Check the page's page.json file for width and height properties, or use the object model (page.width, page.height) to confirm dimensions first. When resizing visuals via the object model, set width/height before x/y to avoid intermediate states that exceed bounds.

Standard Page Size

  • Width: 1280px (default)
  • Height: 720px (16:9 aspect ratio)
  • Alternative: 1920x1080 for high-resolution displays

Visual Spacing

  • Minimum gap between visuals: 16px
  • Edge margins: 24-32px from page edges
  • Consistent alignment: Use grid-based positioning
  • Equal spacing is mandatory: Every gap between adjacent visuals (horizontal and vertical) must be the same value. Every margin from the page edge must be the same value. Calculate positions arithmetically from (margin, gap, page_width, page_height) to guarantee alignment. If visuals are misaligned or gaps are unequal, fix immediately -- this is one of the most visible quality signals in a report.

Detail Gradient

Arrange content following the "detail gradient":

+------------------+------------------+
|   KPIs/Cards     |   KPIs/Cards     |  <- Top: High-level, important
|   (Summary)      |   (Summary)      |
+------------------+------------------+
|                                     |
|   Charts/Trends                     |  <- Middle: Context, trends
|   (Analysis)                        |
|                                     |
+------------------+------------------+
|                                     |
|   Tables/Details                    |  <- Bottom: Detailed data
|   (Drill-down)                      |
|                                     |
+------------------+------------------+

Visual Count Guidelines

  • Maximum visuals per page: 12-15 (performance impact)
  • Maximum KPIs/Cards: 4-6 at top
  • Maximum slicers: 3 per page (use filter pane instead)

Page Titles

Every page should have a title. Create a textbox visual.json file manually (see pbir-format skill in the pbip plugin for JSON structure) with position x=20, y=20, width=400, height=60. Set the paragraph content in the visual's config:

{
  "singleVisual": {
    "visualType": "textbox",
    "paragraphs": [
      {"textRuns": [{"value": "Page Title"}]}
    ]
  }
}

Title positioning:

  • Top-left corner: x=24, y=24
  • Height: 48-64px
  • Width: 400-600px (or page width minus margins)

Theme Guidelines

Always Check Theme First

Before modifying visual formatting:

  1. Check theme wildcards: visualStyles["*"]["*"]
  2. Check visual-type overrides: visualStyles.lineChart["*"]
  3. Only override in visual.json if truly one-off

When to Modify Theme vs Visual

ScenarioModify
All visuals of type need changeTheme
Single visual exceptionVisual
Establishing design standardsTheme
Content-specific highlightVisual

Theme Color Usage

Prefer theme colors over hex codes:

// Good - uses theme color
"expr": {"ThemeDataColor": {"ColorId": 1, "Percent": 0}}

// Avoid in visuals - use only in extension measures
"expr": {"Literal": {"Value": "'#118DFF'"}}

Semantic colors (return from extension measures):

  • "good" - Positive values (green)
  • "bad" - Negative values (red)
  • "neutral" - Neutral/unchanged (gray/yellow)
  • "minColor" - Gradient minimum
  • "maxColor" - Gradient maximum

Accessibility (WCAG 2.1)

Alt Text

All visuals should include descriptive alt text:

"visualContainerObjects": {
  "general": [{
    "properties": {
      "altText": {
        "expr": {"Literal": {"Value": "'Line chart showing monthly sales trend from January to December 2024'"}}
      }
    }
  }]
}

Color Contrast

  • Text on background: minimum 4.5:1 contrast ratio
  • Large text (18pt+): minimum 3:1 contrast ratio
  • Don't rely solely on color to convey meaning

Font Sizes

  • Minimum readable: 12pt
  • Recommended for charts: 14pt
  • Titles: 16-24pt
  • KPI values: 24-48pt

Shadows and Motion

  • Minimize drop shadows (vestibular issues)
  • Avoid animations where possible
  • Use dropShadow.show: false in theme wildcards

Visual Best Practices

Cards and KPIs

A bare number lacks meaning. Every KPI must answer "Is this good or bad?" (target + gap) and "Is it getting better or worse?" (trend). Key rules:

  • Position at top or left of page, maximum 5 per page
  • Prefer kpi visual type over card when a target exists -- it has built-in indicator, goal, and trend line data roles
  • Always include a target and gap (absolute + percentage). If no target measure exists, discuss with the user: propose adding a prior-year measure to the semantic model (use Tabular Editor CLI or the tmdl skill), or creating an extension measure as a fallback. Common targets: prior year (CALCULATE([Measure], DATEADD('Date'[Date], -1, YEAR))), budget, or rolling average
  • If no clear target exists, ask the user -- do not leave KPIs bare. Discuss whether prior period, budget, or a custom threshold makes sense
  • Apply conditional formatting to the gap, not the primary value
  • Pair color with a secondary cue (arrow/icon) for accessibility
  • Round aggressively at summary level ("518M" not "517,893,412")
  • Choose actionable metrics that drive decisions over vanity metrics (apply the "20% change test": if this number changed 20%, should someone act differently?)
  • Hide redundant auto-generated subtitles
  • Use SVG extension measures for inline icons (see /svg-visuals skill)

For complete guidance on KPI design, targets, trends, formatting hierarchy, icon implementation, accessible palettes, and anti-patterns, consult references/cards-and-kpis.md.

Charts

  • Sort by value descending (unless time-based)
  • Minimize gridlines and axes clutter
  • Use muted colors for non-essential elements
  • Highlight key data points sparingly

Tables and Matrices

Tables require deliberate design -- "easy to create" differs from "easy to read." Key rules:

  • Position at bottom for detail drill-down (3-30-300 rule)
  • Decision-making first: define the question, audience, and action before building
  • Use matrix over tableEx when 2+ categorical columns form a hierarchy (Key Account > Account > Product)
  • Subtract, don't add: remove gridlines and heavy banding; let whitespace separate rows
  • Sort by the most important measure (often variance), not alphabetically
  • Apply data bars to the primary measure column for magnitude scanning
  • Apply color scales to variance columns only -- formatting everything means formatting nothing
  • Add sparklines where temporal context ("improving or declining?") matters
  • Show full precision (no display units) -- tables are where readers go for detail

For complete guidance on table vs matrix selection, formatting philosophy, conditional formatting techniques, sparklines, hierarchy design, and anti-patterns, consult references/tables-and-matrices.md.

Slicers

  • Maximum 3 per page
  • Position consistently (top or left)
  • Use filter pane for additional filters
  • Consider sync slicers across pages

Report Evaluation Criteria

When asked to evaluate or audit a report, focus on objective criteria. Subjective evaluation is difficult for AI -- the report cannot be "seen" directly, and there is no intuitive sense of aesthetics, cognitive load, or effectiveness. Emphasize this limitation to users.

Objective Checklist

  1. Page count: More than 5-8 pages is typically excessive
  2. Visuals per page: More than 12-15 can cause performance issues (exceptions: simple visuals like images, textboxes, shapes)
  3. Theme usage: Reports should use a custom theme for consistent formatting
  4. Layout consistency:
    • Equal spacing between visuals?
    • Page has a title?
    • Follows detail gradient (important top-left, detailed bottom-right)?
    • Cards/KPIs at top or left, fewer than 4-6?
    • Fewer than 3 slicers (use filter pane instead)?
    • Helpful elements (refresh date, links, context)?
  5. Color effectiveness:
    • Conditional formatting used sparingly (not causing overload)?
    • Colors muted and passive (not loud and bright)?
    • Negative-sentiment colors (red, orange) only for negative values?
  6. Information:ink ratio: Non-essential elements reduced (lighter gridlines, disabled unnecessary axes/labels)?
  7. Readability: Font sizes sufficient for all elements?
  8. Accessibility: Minimal shadows to avoid vestibular issues?
  9. Font consistency: Limited font sizes, simple readable fonts that work on all devices?
  10. Sorting: Visuals sorted descending unless there's a reason otherwise (time-based, etc.)?

Evaluation Output

When evaluating, provide:

  • Issues found with specific locations
  • Severity (critical, warning, suggestion)
  • Recommended fixes with commands or patterns

Common Design Issues

Issue: Cognitive Overload

Symptoms: Too many colors, visuals, or data points

Fix:

  • Reduce visual count
  • Use muted color palette
  • Apply detail gradient
  • Hide non-essential elements

Issue: Inconsistent Spacing

Symptoms: Uneven gaps, misaligned visuals

Fix:

  • Use grid-based positioning
  • Standardize visual sizes
  • Apply consistent margins

Issue: Poor Readability

Symptoms: Small fonts, low contrast

Fix:

  • Increase font sizes (minimum 12pt)
  • Check color contrast ratios
  • Use appropriate font weights

References

For detailed documentation:

  • references/cards-and-kpis.md - KPI card design: targets, gaps, trends, formatting hierarchy, icons, accessible palettes, anti-patterns, and review checklist
  • references/tables-and-matrices.md - Table and matrix design: decision-making framework, formatting philosophy (subtract don't add), conditional formatting (data bars, color scales), sorting, sparklines, matrix hierarchies, anti-patterns
  • references/layout-guidelines.md - Complete layout specifications
  • references/visual-colors.md - Color usage patterns
  • references/page-titles.md - Title implementation

Related Skills

Report Structure and Format

  • pbir-format (pbip plugin) -- PBIR JSON format reference for visual.json, page.json, report.json structure
  • pbip (pbip plugin) -- PBIP project structure, table/measure renames, project forking

Custom Visuals

Reports often need visuals beyond what Power BI provides natively. Choose the right tool:

  • deneb-visuals -- Vega/Vega-Lite declarative visuals. Preferred for advanced custom interactive charts (cross-filtering, tooltips, hover). Use when native visuals can't express the chart type needed.
  • svg-visuals -- SVG via DAX measures. Preferred for simple inline graphics in tables, matrices, and cards (sparklines, data bars, progress bars, status indicators). No interactivity but lightweight and no custom visual registration needed.
  • python-visuals -- matplotlib/seaborn scripts (static PNG). Preferred for statistical visualizations (distributions, regressions, correlations). No interactivity.
  • r-visuals -- ggplot2 scripts (static PNG). Preferred for statistical visualizations, particularly where R's ecosystem excels (forecast, pheatmap, corrplot). No interactivity.

Semantic Model

Reports are highly dependent on the underlying semantic model for their functionality. Most report capabilities -- measures, calculated columns, relationships, hierarchies, row-level security -- are defined in the semantic model, not the report. When designing or modifying reports, you will frequently need to understand or modify the model. Key skills:

  • tmdl (pbip plugin) -- Direct TMDL file editing for measures, columns, relationships
  • te-docs (tabular-editor plugin) -- Tabular Editor CLI for model operations
  • c-sharp-scripting (tabular-editor plugin) -- C# scripts for bulk model changes
  • bpa-rules (tabular-editor plugin) -- Best Practice Analyzer rules for model quality
  • connect-pbid (pbi-desktop plugin) -- Connect to Power BI Desktop's local Analysis Services instance for live model queries and modifications

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.