The visual calculation on the y-axis of the line would be:

[[email protected]]

MovingAverageThreeQuarters = MOVINGAVERAGE([Sales Amount], 3)

Support for field parameters.

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 bahamas telegram database 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 visual calculation returns for the percentage of grand total.



The visual calculation of the percentage 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.