Visual Calculations in Power BI – Amazing New Feature

[soniya55531]

Discover visual calculations in Power BI, an incredible new feature that will make your calculations easier within Power BI.

If you prefer this content in video lesson format, watch the video below or access our YouTube channel !


To receive the file(s) used in the class by email, fill in:

How to master the fastest growing tool that creates professionals in demand in the Job Market, with the creation of Reports and Dashboards that impress and help in decision making.

Start now
Right arrow
Power BI icon used as backgroundThree images of Power BI course classes
Visual Calculations in Power BI – Amazing New Feature
In today's class, I want to introduce you to this incredible new feature in Power BI: visual calculations . This Power BI update allows you to perform complex calculations with ease, replacing long formulas with simple clicks.

Visual calculations differ from traditional formulas, offering bank data simpler and faster options to apply to specific graphs or tables.

Throughout the class, we will see some examples, such as cumulative calculation, percentage calculation, annual/monthly comparison and percentage growth.

So, download the available material and come with me to learn about the new calculation in Power BI that will make your work much easier.

Introducing the Database
For this class, we will use a database with the sales history of a fictitious company.

database
From this base, we will build our analyses.

Accumulated Calculation – Old Method
Prior to this update, which I will show you how to activate shortly, the method for calculating accumulated values ​​required complex formulas.

Let's create a matrix in the reports tab, with the years and month names in the rows and the revenue in the values.

Headquarters
With this, we will have our matrix displaying sales revenue over the years and months. If we wanted to calculate the accumulated month by month , before this new visual calculation option, we would need to use a more complex formula .

Note that this is a formula that uses several functions to achieve the desired result. However, with visual calculations, this has now become much easier and more efficient.

Enabling Visual Calculations in Power BI
To enable this new feature in Power BI, it is essential to ensure that you are using the latest version of the software. If not, simply perform the Power BI update .

To enable this feature, follow the steps below:

Go to the File tab .
Click Options and Settings , and then click Options .
Within the window that opens, look for Viewing Resources .
Enable the Visual Calculations option.