Sintra AI
Home
Live Feed
Automation Hub
Prompt Library256
AI News554
Weekly Digest
Topic Hubs
AI History
AI Labs
Research
Learning Paths
Guides
Resources
Concepts
Videos
AI Tools74
Models
Claude
Google AI
Cost Calc
Back to Sintra/Data & Analytics
intermediate·Data & Analytics·45 min

Design a Full Power BI Report Page with AI

A labelled page layout blueprint, DAX for every KPI card, a ready-to-use Copilot prompt, and one tailored design tip.

⬡
Recommended modelClaude Sonnet 4.6

Handles complex queries across large datasets

What you need to fill in

[audience, e.g. Sales Director / CFO / Operations team][core business question the page must answer][list available tables][3–5 KPIs with desired format][desired interactions/slicers]

Tools used

Claude SonnetPower BI CopilotPower BI Desktop

The prompt

"I need to design a Power BI report page for [audience, e.g. Sales Director / CFO / Operations team]. Core business question this page must answer: [e.g. 'Are we on track to hit our Q3 revenue target, and which regions are behind?'] Available tables: [list: e.g. Sales, Date, Customer, Product, Region, Targets] Key KPIs to show (3–5): [list with desired format, e.g. 'Revenue — currency, 0 decimals'] Desired interactions: [e.g. slicer by Region, drill-through to product detail] Please produce: 1. A page layout blueprint (label each panel: visual type, size, position) 2. The DAX for each KPI card 3. The Copilot prompt to auto-generate this page in Power BI Service 4. One design tip for this specific audience"
Open in Claude

Sample output

**Page layout blueprint:** ``` ┌──────────────────────────────────────────────────┐ │ KPI Row: [Revenue] [vs Target %] [YoY %] [Open Pipeline] │ ├──────────────────────────────────────────────────┤ │ Main (60% width): Line — Monthly Revenue vs Target by Region │ │ Right (40% width): Bar — Top 10 Accounts by Revenue │ ├──────────────────────────────────────────────────┤ │ Bottom: Matrix — Region × Product (heat map colour scale) │ └──────────────────────────────────────────────────┘ Slicer: Region (top-right, horizontal pill style) ``` **DAX — Revenue vs Target %:** ```dax Revenue vs Target % = VAR _A = [Total Revenue] VAR _T = SUM('Targets'[Revenue Target]) RETURN DIVIDE(_A - _T, _T) ``` **Copilot prompt:** "Create a sales performance page with a KPI row (Total Revenue, Revenue vs Target %, YoY Growth, Open Pipeline), a line chart of Monthly Revenue vs Target by Region, a Top 10 Accounts bar chart, and a Region × Product matrix. Add a Region slicer." **Design tip for Sales Director:** Lead with the traffic-light KPI row — executives scan top-left first. Use conditional formatting (red/green) on the matrix so underperforming cells are instantly visible without reading numbers.

Try with these tools

claudechatgptnotebooklm
power-bireport-designcopilotkpi

More in Data & Analytics

FP&A KPI Dictionary Standardiser

A single KPI dictionary: definition, formula, source system, owner, and refresh cadence per metric.

intermediate

Procurement Spend Cube & Savings Finder

A cleansed spend cube (supplier × category × BU) with ranked savings opportunities.

intermediate

Master Data Golden Record & Dedup Ruleset

A concrete matching, survivorship, and golden-record ruleset for cleaning a customer or vendor master.

advanced