The visualization calculation for the percentage of the total is defined as follows:

Data used to track, manage, and optimize resources.
Post Reply
[email protected]
Posts: 65
Joined: Tue Jan 07, 2025 4:26 am

The visualization calculation for the percentage of the total is defined as follows:

Post by [email protected] »

In the October Power BI update, using visual calculations with field parameters has been enabled. This allows you to add visual calculations to charts that contain field parameters, and vice versa. Field parameters make it easy to quickly change what's shown in a visual. For example, you can create a field parameter to let users choose which attributes of a dimension to show. In this case, a field parameter called "Product Attributes" can determine the percentage of total return for a visual calculation.


Percent of Total = DIVIDE([Sales], COLLAPSEALL([Sales], ROWS))



This visualization is calculated on canada telegram data the ROWS axis, so it will update the value correctly when selecting another product attribute.



Quickly add template-based visual calculations.
Post Reply