Fabric Plan Community Logo
Sign in

SETSCALING

Set custom scaling for a specific measure or an array of measures.

Syntax 

SETSCALING(measures, value)

Arguments

measures - An array of measures or a single measure to set custom scaling.

value - Set to millions/billions/thousands/none, etc. Use the SCALING identifier to access the scaling options supported in Inforiver.

Example 

SETSCALING([2025 Actuals], SCALING.MILLIONS)
//Sets the scaling to millions for the 2025 Actuals measure

Set the scaling to millions for the 2025 Actuals measure

Dynamically control the scaling with scripts:

Using scripts to set the scaling factor

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.