Back to Sintra/Data & Analytics
beginner·Data & Analytics·15 min

Build Any Power BI Chart with a Natural Language Prompt

A ready-to-paste Copilot prompt, the correct visual type with justification, a starter DAX measure, and two formatting tips.

⬡
Recommended modelGPT-5.5 Instant

Strong data reasoning and chart interpretation

What you need to fill in

[chart type, e.g. waterfall / line / scatter / donut][fact table name and relevant columns][date table name][key metric, e.g. Revenue, Units Sold][breakdown dimension, e.g. Region, Product, Month][describe the story you want to show]

Tools used

Power BI CopilotPower BI Desktop

The prompt

"I want to create a [chart type, e.g. waterfall / line / scatter / donut] in Power BI. My data includes: - Fact table: [table name + relevant columns] - Date table: [table name] - Key metric: [e.g. Revenue, Units Sold, Gross Margin] - Breakdown dimension: [e.g. Region, Product, Month] I want to show: [describe the story, e.g. 'how revenue has changed vs. prior year by month'] Please give me: 1. The exact prompt to paste into Power BI Copilot to build this chart 2. Which visual type to select and why 3. Any simple DAX measure I need beforehand 4. Two formatting tips to make it presentation-ready"
Open in ChatGPT

Sample output

**Copilot prompt to paste:** "Create a waterfall chart showing monthly Revenue variance versus prior year. Use the [Sales] table with [Revenue] and [Date].[Month]. Highlight positive months in teal and negative months in red." **Visual type:** Waterfall — best for showing how each month's delta builds up to the total annual variance. **DAX measure to create first:** ```dax Revenue vs PY = [Total Revenue] - CALCULATE([Total Revenue], SAMEPERIODLASTYEAR('Date'[Date])) ``` **Formatting tips:** - Enable data labels to show the exact delta on each bar - Pin the Y-axis to zero so gains and losses are visually comparable

Try with these tools

claudechatgptnotebooklm
power-bicopilotai-chartsnatural-language

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