3.2 · Chart Refinement
[markdown] content available only on the platform
[markdown] content available only on the platform
Flashcards · Chart Refinement
Format pane — The panel for formatting fonts, shading, borders, lines and numbers of a view or workbook.
Right-click the axis → Format → Lines.
Edit Axis — Dialog for setting an axis range (automatic, uniform, independent, fixed), zero, scale and title.
Keep 'Include zero' ticked for bar charts.
Default number format — A measure's number format set once in Default Properties so every view uses it.
Sales: thousands separator, 0 decimals.
Top N filter — A dimension filter that keeps the top or bottom N members by a measure.
Top 5 Sub-Categories by SUM(Sales).
Context filter — A filter applied before Top N, sets and FIXED LOD expressions; shown as a grey pill.
Region filter in context, then Top 5 within it.
Group — A new dimension that combines selected members into a higher-level category.
Same Day and First Class grouped as Express.
Tooltip — The text shown when hovering over a mark; it can be edited and include fields or a chart.
'In <MONTH(Order Date)>, sales were <SUM(Sales)>.'
Reference line — A line from the Analytics pane marking a constant, average, median, min or max.
Average monthly sales line on a trend chart.
Dynamic title — A title that includes field or parameter values so it updates with filters.
'Sales in <YEAR(Order Date)>'
[markdown] content available only on the platform
