FUN-ction-MAS
This function limits down data according to criteria, similar to how Ralphie is selective in wishing for a Red Ryder BB gun in this nostalgic Christmas film.
What is FILTER and A Christmas Story
This custom visual became the top downloaded visual from the marketplace in 2025.
What is the Advanced KPI Tracker?
Power BI integrates natively with this popular spreadsheet software from Microsoft for data analysis and sharing.
What is Excel?
The function that switches row context to filter context, much like how the Grinch's heart grew three sizes after changing his perspective.
What is CALCULATE and How the Grinch Stole Christmas?
This inbuilt Power BI feature adjusts visuals automatically based on the user's selections or filter context, allowing dynamic titles, labels, and color changes.
What is dynamic formatting or conditional formatting?
This was the age that Power BI turned this year, similarly the age that Macaulay Culkin turned upon the release of the movie Home Alone
What is 10?
This iterator function sums values row by row and can include complex filters, similar to how Kevin McCallister outsmarts the burglars using clever, stepwise traps.
What is SUMX and Home Alone?
This visualization displays data points along two axes and is often used to show relationships or trends between two numerical variables.
What is a scatter chart?
The tool used in Power BI to clean and transform data before loading into the model, also available as an Excel add-in
What is Power Query?
This time intelligence function shifts dates backwards or forwards, capturing John McClane’s frantic attempts to save Christmas by moving through time-sensitive events.
What is DATEADD and Die Hard?
This visual uses gauges and dials for enhanced real-time monitoring introduced in 2025.
What is Real-Time Dial Gauge?
In 2025, this major sporting event used Power BI dashboards for real-time audience analytics.
What is FIFA Women’s World Cup?
This function returns the position of a substring within a text string, similar to how Buddy tracks down his dad’s office in the big city.
What is SEARCH and Elf?
This 2025 custom visual enables predictive forecasting with interactive sliders.
What is Predictive Forecast Visual?
This country adopted Power BI as the standard reporting tool for all government agencies in 2025.
What is Singapore?