Quickly add visual calculations based on templates.
Posted: Wed Jan 08, 2025 3:50 am
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 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.
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 romania whatsapp resource 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.
In October's Power BI updates, the Azure Maps visual has been significantly improved with the addition of data-bound reference layers.
Previously, reference layers in Azure Maps were static and did not allow for conditional formatting or linking of geometries to customer business data. This limitation also impacted user interaction, as actions such as selecting, filtering, clicking, or accessing tooltips could not be performed for polygons and points, unlike other visual components.
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.
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 romania whatsapp resource 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.
In October's Power BI updates, the Azure Maps visual has been significantly improved with the addition of data-bound reference layers.
Previously, reference layers in Azure Maps were static and did not allow for conditional formatting or linking of geometries to customer business data. This limitation also impacted user interaction, as actions such as selecting, filtering, clicking, or accessing tooltips could not be performed for polygons and points, unlike other visual components.