Small multiples

Use the IBCS small multiples template to compare the same metric across multiple categories in a consistent layout. Each panel uses the same scale and formatting, making it easier to identify patterns and differences.

Small multiples work best with chart types that share a common scale and are intended for repeated comparison across categories

Configuration optionConfiguration value
Chart typeBar/Column/Area/Line/Waterfall.
CategoryAssign the dimension that defines the columns along the x-axis. The chart displays each unique value as a separate column. Example: Month.
Actual(s)Assign one or more measures to analyze. The values determine the height of each stacked column or segment. Example: Profit - Actual.
Comparison 1-3(vs Actuals)

Assign up to three additional measures to compare with the actual values. The chart displays each comparison measure as a separate column or an overlapped column for the same category.

This is optional. Example: Profit - Prior Year, Profit - Forecast.

Trellis RowAssign a dimension to plot trellis panels. Each category is shown as a separate chart. Example: Product.
Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.