The visual calculation of the percentage

[[email protected]]

MovingAverageThreeQuarters = MOVINGAVERAGE([Sales Amount], 3)


In the October Power BI updates, we've enabled the use of visual calculations with field parameters. This allows you to add a visual calculation to a chart that contains a field parameter, and vice versa. Field parameters make it easy to quickly change what's displayed in a visual. For example, you can create a field parameter to let users choose which attributes of a dimension to display. In this case, a field parameter called “Product Attribute” can determine what the italy whatsapp resource visual calculation returns for the percentage of grand total.



of the grand total is defined as follows:

Percentage of grand total = DIVIDE([Sales Amount], COLLAPSEALL([Sales Amount], ROWS))

This visual calculation refers to ROWS as its axis, so it will update the values ​​correctly when you select another product attribute.

Quickly add visual calculations based on templates.

You can now add visual calculations based on templates with fewer clicks. Simply click the bottom of the “New Visual Calculation” button on the ribbon to see a menu of available templates. Selecting a template will open the visual calculation mode where you can fill out the template and add your visual calculation. If you prefer to create a visual calculation without a template, select the top of the “New Visual Calculation” button or choose “Custom” from the template menu.