Visual Calculations: Field Parameters field

[abpgupta]

Hi All

Is it possible to update Visual calculations and results based on field parameter? I see some will depend on sorting and grouping defined in visual so that can change depending on different attribute/dimension selection as well as measure selection using field Parameters.

Thanks for inputs.  

[lbendlin · Accepted solution]

I am pretty sure this will work for columns as field parameters, as the visual calculations focus on the values part of the visual.  But for measures that may not be possible as the value identifier changes.

off to do some testing on this...

[Anonymous · Accepted solution]

Hi @abpgupta ,
Thanks to @lbendlin for the reply.
Here is what I need to add.
Filed parameter can be used to dynamically display columns or measures, it will also sort them in ascending or descending order according to your initial columns.Filed parameter can be used to make a table with multiple measures to be displayed in the state desired by the user.
For more details you can refer to the following documentation
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin · Accepted solution]

I am pretty sure this will work for columns as field parameters, as the visual calculations focus on the values part of the visual.  But for measures that may not be possible as the value identifier changes.

off to do some testing on this...