Sign in to watch this episode

Episodes are free for Fabric Planning Community members.

or
 · 
 · Episode 4
4:04 min

A checkbox on its own does nothing. This episode puts one to work. We create Price Change as a Boolean checkbox visual measure, checked by default for every month. Then we edit Price Forecast and set Allow input to Based on formula, with Price Change != 0. Uncheck a cell and its price is greyed out and locked. Change a total and the spread skips the locked cell while the subtotals still average correctly.


Part of Planning · Season 2

Mastering Measures

View all 10 episodes
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.