Menú
Creates Power BI report themes for consistent styling. Use for colors, fonts, visual defaults, and corporate branding.
Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.
Basado en la clasificación ocupacional SOC
Applies Power BI best practices, BPA rules, and enterprise standards. Use for quality validation, naming conventions, and performance optimization.
Creates calculation groups for reusable DAX patterns like time intelligence and currency conversion. Use to replace repetitive measures with dynamic calculations.
Writes DAX measures, calculated columns, and calculations for Power BI. Use for business logic, time intelligence, and analytical calculations.
Implements CI/CD pipelines and DevOps practices for Power BI. Use for automated validation, testing, and deployment of PBIP projects.
Creates and manages Power BI Desktop Project (PBIP) structure. Use when starting new Power BI projects, setting up folder structure, or configuring project files.
Writes Power Query (M language) for data transformation, connections, and ETL. Use for data sources, transformations, parameters, and query optimization.
| name | themes |
| description | Creates Power BI report themes for consistent styling. Use for colors, fonts, visual defaults, and corporate branding. |
This skill helps create Power BI report themes for consistent visual styling and branding.
Themes are JSON files with .json extension. They can be:
{
"name": "Custom Theme",
"dataColors": ["#118DFF", "#12239E", "#E66C37", "#6B007B", "#E044A7", "#744EC2"],
"background": "#FFFFFF",
"foreground": "#252423",
"tableAccent": "#118DFF"
}
| Property | Description |
|---|---|
dataColors | Array of colors for data series |
background | Default background color |
foreground | Default text color |
tableAccent | Accent color for tables/matrices |
hyperlink | Link color |
good | Positive/good indicator |
neutral | Neutral indicator |
bad | Negative/bad indicator |
{
"textClasses": {
"label": {
"fontFace": "Segoe UI",
"fontSize": 12,
"color": "#252423"
},
"title": {
"fontFace": "Segoe UI Semibold",
"fontSize": 14,
"color": "#252423"
},
"header": {
"fontFace": "Segoe UI Semibold",
"fontSize": 12,
"color": "#252423"
},
"callout": {
"fontFace": "Segoe UI Light",
"fontSize": 28,
"color": "#252423"
},
"largeTitle": {
"fontFace": "Segoe UI Light",
"fontSize": 40,
"color": "#252423"
}
}
}
| Class | Used For |
|---|---|
label | Data labels, axis labels |
title | Visual titles |
header | Table/matrix headers |
callout | Card values, KPI values |
largeTitle | Large display values |
{
"name": "Corporate Theme",
"dataColors": [
"#0078D4",
"#00BCF2",
"#00B294",
"#FFB900",
"#E81123",
"#5C2D91",
"#B4009E",
"#107C10"
],
"background": "#FFFFFF",
"foreground": "#323130",
"tableAccent": "#0078D4",
"hyperlink": "#0078D4",
"good": "#107C10",
"neutral": "#FFB900",
"bad": "#E81123",
"maximum": "#107C10",
"center": "#FFB900",
"minimum": "#E81123",
"textClasses": {
"label": {
"fontFace": "Segoe UI",
"fontSize": 11,
"color": "#605E5C"
},
"title": {
"fontFace": "Segoe UI Semibold",
"fontSize": 14,
"color": "#323130"
},
"header": {
"fontFace": "Segoe UI Semibold",
"fontSize": 12,
"color": "#323130"
},
"callout": {
"fontFace": "Segoe UI",
"fontSize": 28,
"color": "#323130"
}
},
"visualStyles": {
"*": {
"*": {
"background": [{
"color": { "solid": { "color": "#FFFFFF" } },
"transparency": 0
}],
"border": [{
"show": false
}],
"dropShadow": [{
"show": false
}]
}
}
}
}
{
"visualStyles": {
"<visualType>": {
"<propertyGroup>": {
"<property>": [{ <settings> }]
}
}
}
}
| Wildcard | Meaning |
|---|---|
"*" | All visuals / all properties |
| Type | Description |
|---|---|
"*" | All visuals |
"page" | Report page |
"card" | Card visual |
"multiRowCard" | Multi-row card |
"columnChart" | Column chart |
"barChart" | Bar chart |
"lineChart" | Line chart |
"pieChart" | Pie chart |
"donutChart" | Donut chart |
"tableEx" | Table |
"pivotTable" | Matrix |
"slicer" | Slicer |
"kpi" | KPI visual |
"gauge" | Gauge |
"map" | Map |
"shape" | Shape |
"textbox" | Text box |
| Group | Properties |
|---|---|
background | Visual background |
border | Visual border |
dropShadow | Shadow effect |
title | Visual title |
subTitle | Subtitle |
legend | Legend settings |
categoryAxis | X-axis |
valueAxis | Y-axis |
labels | Data labels |
dataPoint | Data point colors |
{
"visualStyles": {
"*": {
"*": {
"background": [{
"color": { "solid": { "color": "#FFFFFF" } },
"transparency": 0
}],
"border": [{
"show": true,
"color": { "solid": { "color": "#E0E0E0" } },
"radius": 5
}],
"dropShadow": [{
"show": true,
"color": { "solid": { "color": "#000000" } },
"position": "Outer",
"preset": "BottomRight",
"transparency": 80
}],
"title": [{
"show": true,
"fontColor": { "solid": { "color": "#252423" } },
"fontSize": 14,
"fontFamily": "Segoe UI Semibold",
"alignment": "left"
}]
}
}
}
}
{
"visualStyles": {
"card": {
"*": {
"labels": [{
"color": { "solid": { "color": "#0078D4" } },
"fontSize": 32
}],
"categoryLabels": [{
"show": true,
"color": { "solid": { "color": "#605E5C" } },
"fontSize": 12
}],
"background": [{
"color": { "solid": { "color": "#F3F2F1" } }
}]
}
}
}
}
{
"visualStyles": {
"columnChart": {
"*": {
"categoryAxis": [{
"show": true,
"labelColor": { "solid": { "color": "#605E5C" } },
"fontSize": 11,
"gridlineShow": false
}],
"valueAxis": [{
"show": true,
"labelColor": { "solid": { "color": "#605E5C" } },
"fontSize": 11,
"gridlineShow": true,
"gridlineColor": { "solid": { "color": "#E0E0E0" } }
}],
"legend": [{
"show": true,
"position": "Top",
"fontSize": 11,
"fontColor": { "solid": { "color": "#605E5C" } }
}],
"labels": [{
"show": false
}]
}
}
}
}
{
"visualStyles": {
"tableEx": {
"*": {
"grid": [{
"gridVertical": true,
"gridVerticalColor": { "solid": { "color": "#E0E0E0" } },
"gridHorizontal": true,
"gridHorizontalColor": { "solid": { "color": "#E0E0E0" } },
"rowPadding": 4
}],
"columnHeaders": [{
"fontColor": { "solid": { "color": "#FFFFFF" } },
"backColor": { "solid": { "color": "#0078D4" } },
"fontSize": 12,
"bold": true
}],
"values": [{
"fontColor": { "solid": { "color": "#323130" } },
"fontSize": 11
}],
"total": [{
"fontColor": { "solid": { "color": "#323130" } },
"backColor": { "solid": { "color": "#E0E0E0" } },
"bold": true
}]
}
}
}
}
{
"visualStyles": {
"slicer": {
"*": {
"header": [{
"show": true,
"fontColor": { "solid": { "color": "#252423" } },
"fontSize": 14
}],
"items": [{
"fontColor": { "solid": { "color": "#323130" } },
"fontSize": 11
}],
"selection": [{
"selectAllCheckboxEnabled": true,
"singleSelect": false
}]
}
}
}
}
{
"visualStyles": {
"page": {
"*": {
"background": [{
"color": { "solid": { "color": "#F3F2F1" } },
"transparency": 0
}],
"wallpaper": [{
"color": { "solid": { "color": "#F3F2F1" } }
}]
}
}
}
}
{
"dataColors": [
"#118DFF",
"#12239E",
"#E66C37",
"#6B007B",
"#E044A7",
"#744EC2",
"#D9B300",
"#D64550"
]
}
{
"dataColors": [
"#0078D4",
"#00BCF2",
"#004578",
"#5C2D91",
"#B4009E",
"#008272",
"#00B294",
"#002050"
]
}
{
"dataColors": [
"#5B5EA6",
"#9B2335",
"#00A4CC",
"#E4712B",
"#3A4D39",
"#8B6914",
"#6B4226",
"#4A5859"
]
}
{
"dataColors": [
"#000000",
"#E69F00",
"#56B4E9",
"#009E73",
"#F0E442",
"#0072B2",
"#D55E00",
"#CC79A7"
]
}
{
"dataColors": [
"#00BCF2",
"#00CC6A",
"#FFB900",
"#E81123",
"#B4009E",
"#10893E",
"#FF8C00",
"#6B69D6"
],
"background": "#1E1E1E",
"foreground": "#FFFFFF",
"tableAccent": "#00BCF2"
}
{
"bad": "#E81123",
"neutral": "#FFB900",
"good": "#107C10"
}
{
"minimum": "#FFFFFF",
"center": "#00BCF2",
"maximum": "#0078D4"
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/report/1.0.0/schema.json",
"themeCollection": {
"baseTheme": {
"name": "CY24SU06",
"reportVersionAtImport": "5.55",
"type": "SharedResources"
},
"customTheme": {
"name": "CustomTheme",
"reportVersionAtImport": "5.55",
"type": "Custom"
}
}
}
Store custom theme file in StaticResources/ folder of the report.