Indent VAR, RETURN, and nested calls. Nothing is sent to a server.
Calendar table
Generate a date table in DAX or M. After you load it, mark the Date column as a date table in Model view.
Columns
Time intelligence
Build ready-to-paste measures from a date table and a base measure. YoY % includes a prior-year measure if you have not selected one.
Measures to copy
Measure patterns
Choose a frequently used measure script. Only the fields that pattern needs are shown.
DIVIDE returns BLANK when the denominator is zero or blank, instead of an error.
Model
Paste TMDL
Sample loads a mock model, pages, and sources. A real .pbix includes the report. Stays in the browser.
Objects
Import an existing theme.json
Optional. Load a file or paste JSON, then edit the colours below.
Start from a palette
Pick a starting set, then edit below. Okabe–Ito and Paul Tol are colour-blind-safe. This page does not simulate colour vision.
Page
Background, text, and table accent used on the report page.
Sentiment
KPI and conditional formatting: good, neutral, and bad.
Chart series
Colours used in charts, in order. Six to twelve series.
Preview
Page, KPI, and the first three series colours. This is not a Power BI visual.
Report
Sales overview
£1.24m
Contrast
| Pair | Sample | Ratio | WCAG |
|---|
View
Drag a table to move it. Drag empty canvas to pan. 1 / * is cardinality. Dashed lines are inactive.
Sources