Power BI Enhancements You Need to Know – Part 7: Visual Calculations in Power BI

[anmolmalviya05]

What Are Visual Calculations?

Visual calculations allow you to write DAX expressions directly within a visual—not in the model. Think of them as visual-specific calculations that make it easier to implement common business logic like running totals, moving averages, and custom comparisons without creating new measures or columns.

Example:

Key highlights:

• Simpler DAX, better performance
• Works only with data present in the visual
• Calculated at the visual level, not in the model
• Ideal for ad-hoc analysis and quick prototyping

How to Enable and Use Visual Calculations

Step 1: Enable the Feature (if needed)

• Before September 2024: Go to Options > Preview Features > Enable Visual Calculations, then restart Power BI.
• After September 2024: Enabled by default (still in preview).

Step 2: Add a Visual Calculation

• Select a visual (e.g., table, matrix, chart).
• Click on “New visual calculation” in the Home ribbon.
  
• Use the formula bar to define your logic.
  

  Tip: No need to write SUM or CALCULATE unless aggregation is needed. Visual calculations behave like row-wise evaluations, similar to calculated columns.

Key Benefits of Visual Calculations

Benefit	Description
Simplified DAX	Write quick logic without complex syntax.
Performance Gains	Operate on aggregated data rather than detail-level.
No Model Clutter	Doesn't add temporary measures to your semantic model.
Ad-hoc Friendly	Perfect for analysis that doesn't need to persist.
Visual Context Awareness	Automatically respects the structure and filters of the visual.

Templates & Quick Calculations

Templates are accessible via the drop-down under the New visual calculation button.

Limitations to Keep in Mind

Since visual calculations are still in preview, they come with a few restrictions:

Not supported on:

• Slicers, R/Python visuals, Key Influencer, Q&A, Decomposition Tree
• Metrics, Paginated Reports, Power Apps, Power Automate
• Cannot be reused or copied across visuals
• Not exportable in "underlying data" exports
• Not supported in Power BI Embedded or Publish to Web
• No personalization, sort order, or dynamic format strings
• Self-referencing calculations not allowed

Final Thoughts

Visual Calculations in Power BI are a game-changer for analysts who want to create dynamic insights quickly without diving deep into complex DAX or expanding their data model unnecessarily.

They are simple, performant, and perfect for storytelling, especially during exploratory analysis or prototyping dashboards.

Regards
Anmol Malviya

Proud to be a Microsoft Fabric community super user

Let's Connect on LinkedIn

Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.