Exciting News in Power BI — Boost your Power BI experience with Visual Calculations

Mohd Zaid
2 min readSep 15, 2024

--

Unlock the power of simplicity with Visual Calculations in Power BI! 💡
Visual calculations are a game-changer, allowing you to define and execute DAX calculations directly on a visual. No more navigating the complexities of the semantic model — just a streamlined process for writing DAX.
Here’s how to get started:

Enable Visual Calculations in Options and Settings ➡️ Options ➡️ Preview features.
Select your visual, click the New Calculation button, and dive into the Visual Calculations edit mode.

📊 Three Key Components:

Visual Preview: See the visual you’re working with.
Formula Bar: Add visual calculations effortlessly.
Visual Matrix: Watch your visual calculations come to life as you add them.

Benefits:

✨ Visual calculations are evaluated row-by-row, enhancing readability.
✨ Leverage DAX functions and specific visual calculation functions like RUNNINGSUM, PREVIOUS, and MOVINGAVERAGE.
✨ Visual calculations operate on aggregated data, offering performance benefits.
🔒 Unlike traditional calculations, Visual Calculations are stored on the visual, simplifying complexities of filter context and the model.
💻 Easier and Faster Option:
Visual calculations do not need to worry about the model’s complexity.
Flexibility to refer to the visual structure.
Enjoy improved performance benefits by operating on aggregated data.

✨ Bonus Tip: Hide unnecessary fields from the visual without affecting your calculations.

🚀 Elevate your Power BI experience with Visual Calculations — making the impossible calculations a breeze! 🚀

Originally published at https://www.linkedin.com.

--

--

No responses yet