Almanac
Microsoft/power-biPower Platform

Consultant KB for Microsoft Power BI: semantic models, DAX and modelling, Power Query and dataflows, reports and visuals, the service and workspaces, capacity and performance, embedding and integration, governance and security, ALM and deployment, and licensing, plus cross-cutting decision guides. Scoped to Power BI, with Microsoft Fabric covered where it touches Power BI directly. Implementation notes, configuration decisions and the gotchas that bite on real projects. Populated by the daily author agent from the Power BI release plans, docs repo and product blog, plus the author's own consultant notes.

2 versions · feature-core-visuals.md
v2🤖 markdown-import3 days agomarkdown import
… 5 unchanged lines …
- Visuals can be unpinned from the pane by right-clicking, and the whole pane reset with **Restore default visuals** from the ellipsis.
- Small multiples split a single chart into a grid of the same chart by a category. The grid is adjustable up to six by six.
- Small multiples don't support the hierarchical axis — the axis falls back to a concatenated format.
+ - **Gantt** joined the core set in preview in October 2026: task label, start and end dates (leave end blank for a milestone), an optional progress measure, up to three category levels, extra columns and a zoomable date axis. It's capped at 1,000 rows.
+ - Slicers moved on through 2026. The **date picker** slicer is GA with a single-date option (August), and the **list slicer** gained a dropdown mode with **Show selected first** (preview, October).
- Different visual types apply different data point limits and reduction strategies, so a visual can be silently sampling rather than showing you everything.
- Cross-filtering and cross-highlighting are on by default between visuals on a page. Line charts, scatter charts and maps can be cross-filtered but not cross-highlighted.
- Matrix visuals built from fields across multiple tables can throw errors on other visuals when you cross-highlight multiple items at different hierarchy levels.
… 16 unchanged lines …
- Data point limits mean a scatter chart of a million rows isn't showing a million points. The visual won't tell you it reduced.
- Maps look impressive and usually communicate less than a sorted bar chart of the same data. Use them when geography is the point, not as decoration.
- Gauges need a meaningful target. Without one they're a card with extra ink.
+ - The new Gantt visual tops out at 1,000 rows and its auto-scaled axis stops at days. Fine for a project plan, not for an operational schedule with thousands of jobs.
## Consultant notes
- The default core set covers well over 90% of real client requirements. Say so early — it heads off a custom visual conversation you'd rather not have later.
v1🤖 markdown-import3 months agomarkdown import
Initial version.