Golden Dashboard Creator Skill

This skill helps you build a "Golden-Themed" premium dashboard in Power BI. It focuses on aesthetics, layout, and visual configuration to achieve a luxury look.

Core Design Principles

1. •Color Palette:
   • •Background: Deep Black (#000000) or Dark Charcoal (#1A1A1A).
   • •Primary Accent (Gold): Bright Gold (#FFD700) or Metallic Gold (#D4AF37).
   • •Secondary Accent: White (#FFFFFF) for text, Dark Grey (#333333) for container backgrounds.
2. •Typography: Clean, sans-serif fonts (e.g., DIN, Segoe UI Semibold).
3. •Layout: Grid-based, spacing between visuals, rounded corners (10-15px) for visual containers.

Instructions

1. Apply the Golden JSON Theme

Save the following as GoldenTheme.json and import it into Power BI (View -> potentially "Browse for themes"):

{
  "name": "Golden Luxury",
  "dataColors": ["#FFD700", "#D4AF37", "#FFFFFF", "#C0C0C0", "#808080"],
  "background": "#000000",
  "foreground": "#FFFFFF",
  "tableAccent": "#FFD700",
  "visualStyles": {
    "*": {
      "*": {
        "background": [{ "color": { "solid": { "color": "#1A1A1A" } }, "transparency": 0 }],
        "border": [{ "show": true, "radius": 10, "color": { "solid": { "color": "#333333" } } }],
        "outspace": [{ "color": { "solid": { "color": "#000000" } } }]
      }
    },
    "card": {
      "*": {
        "labels": [{ "color": { "solid": { "color": "#FFFFFF" } } }],
        "categoryLabels": [{ "color": { "solid": { "color": "#FFD700" } } }]
      }
    }
  }
}

2. Dashboard Layout Setup

• •Header: Rectangle shape at the top (Color: #1A1A1A), Height: 80px. Title in White, Size 20+.
• •KPI Cards: Place 3-4 cards at the top, just below the header.
• •Slicers: Vertical pane on the left or horizontal bar below KPIs. Use "Dropdown" or "Tile" style with Gold background for selected items.

3. Visual Configuration Examples

KPI Cards (Sales & Profit)

• •Metric: Total Sales, Total Profit.
• •Style:
  • •Callout Value: White #FFFFFF, Font Size 35.
  • •Category Label: Gold #FFD700, Font Size 12.
  • •Background: Dark Grey #1A1A1A.
  • •Shadow: On, Black, Offset 5px.

Charts (Sales Trend)

• •Visual: Line Chart.
• •Axis: Sales vs. Date.
• •Style:
  • •Line Color: Gold #FFD700.
  • •Stroke Width: 3px.
  • •Gridlines: Off or very faint grey #333333.
  • •Data Labels: On, White #FFFFFF.

Charts (Top Products)

• •Visual: Bar Chart.
• •Axis: Profit vs. Product.
• •Style:
  • •Bars: Gradient or Solid Gold #D4AF37.
  • •Background: #1A1A1A.

4. Tooltips

Create a separate page named "Tooltip". Set Page Information -> Tooltip = On.

• •Background: #333333.
• •Add a Donut Chart or Multi-row Card showing detailed breakdown (e.g., Sales by Region for that Product).

Few-Shot Example

User Input: "Create a sales dashboard for exec_sales.csv."

Response:

1. •Theme: Import GoldenTheme.json.
2. •KPIs: Card 1 (Sales: $1.2M), Card 2 (Profit: $300K), Card 3 (Margin: 25%).
3. •Main Chart: Area chart showing Monthly Sales trend (Gold fill area).
4. •Breakdown: Bar chart for Top 5 Sales Reps (Gold bars).
5. •Slicer: "Year" and "Region" styled with Gold font on Dark background.