Data Roles
Data roles define what data fields your visual accepts. Each visual has its own set of data roles.
Column Chart Data Roles
| Data Role | Type | Description |
|---|---|---|
| Axis | Grouping | The category axis (X axis for columns, Y axis for bars) |
| Values | Measure | The numeric values to display as bars |
| Legend | Grouping | Splits bars into series with distinct colors |
| Series Color | Measure/Grouping | Hex color code (e.g. #FF0000) per legend value |
| Logo | Measure/Grouping | Base64-encoded image per legend value |
| Error Bar Upper | Measure | Upper bound for error bars (By Field mode) |
| Error Bar Lower | Measure | Lower bound for error bars (By Field mode) |
| Base (sample size) | Measure | Sample size used as n by the significance tests |
| Standard Deviation | Measure | Standard deviation per series and per point. Switches the significance test from proportions to means |
| Add. Table | Measure | Extra cells beside the marks — columns beside the bars, rows under or over the columns — see Add. Table |
| Significance reference | Measure | Reference of an External reference significance test, as JSON — not drawn |
Line Chart Data Roles
| Data Role | Type | Description |
|---|---|---|
| Axis | Grouping | The category axis (X axis) |
| Values | Measure | The numeric values (Y axis) |
| Legend | Grouping | Splits into multiple line series |
| Series Color | Measure/Grouping | Hex color code per legend value |
| Logo | Measure/Grouping | Base64-encoded image per legend value |
| Error Bar Upper/Lower | Measure | Bounds for error bars |
| Base (sample size) | Measure | Sample size per category, shown by the base row and used as n by the significance tests |
| Standard Deviation | Measure | Standard deviation per series and per point. Switches the significance test from proportions to means |
| Significance reference | Measure | Reference of an External reference significance test, as JSON — not drawn |
| Add. Table | Measure | Rows of values drawn above or under the chart, one cell per category — see Add. Table |
Scatter Plot Data Roles
| Data Role | Type | Description |
|---|---|---|
| Values (Labels) | Grouping | Labels for each data point |
| X Axis | Measure | Horizontal position |
| Y Axis | Measure | Vertical position |
| Legend | Grouping | Color grouping |
| Size | Measure | Bubble size encoding |
| Tooltips | Measure | Additional tooltip values |
| Color | Measure | Data-driven point colors |
| Logo | Measure/Grouping | Base64-encoded image per legend value |
Gradient Heatmap Data Roles
| Data Role | Type | Description |
|---|---|---|
| X Axis | Measure/Grouping | Horizontal position of each sample point |
| Y Axis | Measure/Grouping | Vertical position of each sample point |
| Value | Measure/Grouping | The measure shading the surface |
| Category (sample id) | Grouping | Identifies each sample point and labels it |
| Tooltips | Measure/Grouping | Additional tooltip values |
Radar Data Roles
| Data Role | Type | Description |
|---|---|---|
| Axis | Grouping | One spoke of the web per value; each axis carries its own scale |
| Values | Measure | The measure plotted along each axis |
| Legend | Grouping | Splits the web into one thread per series |
| Series Color | Measure/Grouping | Hex color code, read per legend value or per axis |
| Logo | Measure/Grouping | Base64 image, read per legend value and per axis |
| Base (sample size) | Measure | Sample size used as n by the significance tests |
| Standard Deviation | Measure | Feeds the significance test on means (the test itself is chosen by Test On) |
| Significance reference | Measure | Reference of an External reference significance test, as JSON — not drawn |
| Tooltips | Measure | Additional tooltip values |
Pie Chart Data Roles
| Data Role | Type | Description |
|---|---|---|
| Category | Grouping | One slice per value |
| Values | Measure | The measure sliced by the pie |
| Legend | Grouping | One chart per value — small multiples or concentric rings |
| Series Color | Measure/Grouping | Hex color code, read per category or per legend value |
| Logo | Measure/Grouping | Base64 image, read per category (legend) and per legend value (series titles) |
| Base (sample size) | Measure | Sample size used as n by the significance tests |
| Standard Deviation | Measure | Switches the significance test from shares to means |
| Significance reference | Measure | Reference of an External reference significance test, as JSON — not drawn |
| Tooltips | Measure | Additional tooltip values |
Series Color
The Series Color data role allows you to control series colors directly from your data model. Simply create a column or measure that returns a hex color code:
SeriesColor = SWITCH(
SELECTEDVALUE(Products[Category]),
"Electronics", "#4682B4",
"Clothing", "#FF6347",
"Food", "#32CD32",
"#888888"
)
The role is called Color on the scatter plot. The Gradient Heatmap has none — its colors come from the color scale instead. On the radar and the pie chart the role feeds one dimension at a time, chosen by the Apply colors to dropdown of the visual's main card.
Color Resolution Priority
Colors are resolved in this order:
- Per-series conditional formatting (fx) from Power BI
seriesColordata role value- Host color palette
- Default 10-color array
Logo
The Logo data role accepts base64-encoded images. If the value doesn't start with data:, the visual automatically prepends data:image/png;base64,.
Logos can appear in:
- The legend (column, line, scatter, radar and pie)
- End-of-line labels (line chart)
- Inside bars (column chart)
- At the outer end of each axis (radar)
- In the title of each small multiple (pie chart)
The Gradient Heatmap has no Logo role.