Visual calculations are a preview feature in Power BI designed to simplify measure creation directly within a visual. Rather than building complex DAX measures that must account for multiple contexts and scenarios, users can create calculations that operate specifically within the selected visual. This approach makes it much easier to develop calculations such as:
- Running sums
- Moving averages
- Percent-based calculations
- Comparison calculations
- Time-window calculations
Visual calculations also include built-in templates that help users create common calculations quickly, making the feature particularly useful for users who are newer to DAX.
Creating a simple visual calculation
To demonstrate the feature, Simon begins with a matrix visual containing Order Date, Order Quantity, and Sales Amount.
After selecting the visual and choosing New Visual Calculation, Power BI opens the Visual Calculations workspace. This workspace displays both the visual and a calculation area where users can create and test calculations. One example is an Average Item Price calculation created by dividing Sales Amount by Order Quantity. As calculations are built, Power BI highlights the fields being used and provides an intuitive editing experience that makes formula creation easier. Once committed, the calculation appears in the visual just like a traditional measure.
Understanding the first limitation
One important limitation is that visual calculations are tied directly to the visual where they are created. This means:
- The calculation cannot be reused elsewhere in the report.
- It will not appear as a standard measure in the data pane.
- If the visual is deleted, the calculation is deleted as well.
For one-time calculations this tradeoff may be acceptable, but reusable business metrics are generally better suited for traditional measures.
Understanding the second limitation
Visual calculations can only use data that already exists within the visual. For example, if a chart contains only a date field, Power BI will not allow a calculation to reference Sales Amount or Order Quantity unless those fields are also included in the visual. Fortunately, Power BI allows users to:
- Add fields needed for calculations
- Hide those fields from display
- Continue using them behind the scenes within calculations
This approach keeps visuals clean while still providing access to the data required for calculations.
Using running sum templates
One of the most valuable aspects of visual calculations is the collection of built-in templates.
A running sum can be created by selecting the Running Sum template and specifying a single field, such as Sales Amount.
While running sums are not especially difficult to create in DAX, building versions that work correctly across multiple rows, columns, filters, and hierarchies can be time-consuming.
Visual calculations simplify this process because the visual itself handles much of the context management automatically.
How visual calculations differ from traditional measures
A powerful distinction is how calculations respond to visual changes.
In Simon’s example, a traditional running-sum measure is compared with a visual calculation running sum.
Initially, both return identical results. However, when the sorting order of the visual changes, the behavior becomes different:
- Traditional measures continue following their underlying DAX logic.
- Visual Calculations follow the order displayed in the visual.
Because visual calculations rely on visual context, they can feel more intuitive when users sort, filter, or reorganize data within a report.
Building moving averages
Another useful template is the Moving Average calculation. A moving average requires:
- A value field
- A window size
For example, a window size of seven will calculate a rolling average over the previous seven visible periods.
However, visual calculations operate at the level currently being displayed:
- Day view = 7 days
- Month view = 7 months
- Quarter view = 7 quarters
- Year view = 7 years
This may not always produce the desired result.
Adding more control with DAX
Although visual calculations provide templates, they are still written in DAX. This means users can apply familiar DAX techniques to customize behavior.
Simon demonstrates a custom Moving Average calculation using:
- SWITCH statements
- Scope checks
- Different window sizes at different hierarchy levels
Examples include:
- 7-day moving averages
- 6-month moving averages
- 4-quarter moving averages
- 3-year moving averages
By combining visual calculations with DAX, users can create more sophisticated and flexible calculations while still benefiting from the visual-driven approach.
Additional visual calculation templates
Power BI includes several other templates designed to simplify reporting:
- Percentage calculations
- Previous value calculations
- Next value calculations
- First and last value calculations
- Lookup calculations
These templates use the visual’s hierarchy and structure automatically, reducing the need to hardcode complex logic into measures. Users can also write entirely custom DAX calculations when template functionality does not meet their requirements.
Current feature limitations
Because visual calculations are still a preview feature, support is not available across all visual types. Some visuals:
- Do not support visual calculations at all
- Only support certain calculation types
- Have functionality limitations that continue to evolve as Microsoft expands the feature
Users should review Microsoft’s current documentation to understand which visuals and calculation patterns are supported.
Key takeaways
Visual calculations offer a fast and intuitive way to create calculations directly within Power BI visuals.
Benefits include:
- Faster creation of complex calculations
- Built-in templates for common reporting needs
- Simplified handling of context and scope
- Easier development of running totals and moving averages
Limitations include:
- Calculations are restricted to a single visual
- Only fields present in the visual can be used
- Not all visuals currently support the feature
For many reporting scenarios, visual calculations can significantly reduce development time while making advanced calculations more accessible to Power BI users.
