Dynamic formatting field parameter (abs/%)

[ClaraBcn]

Dear network,

I have 3 field parameters with the same measures inside them.

I.e: Main scenario with A23, A22, A32, B24, etc and Comparsion scenario 1 & 2 with the same measures inside. Goal of this is to have a dynamic dahsboard which fits the user needs.

We also have a switch measure whith Value and % which is then taken by the field parameter (selectedvalue). The issue comes when I need to format the field parameter depending on the selection of the user to absolute value or %. The formatting of the field parameter is very restricted and I'm not able to do it.

I have also tried using calc groups, but then it is overwritting field parameter choice.

Does anyone have any advice?

I am also struggling to give an appropriate order based on Main scenario, as the order can be only selected by measure (and all measures are shared across all field parameter)..

If someone could also help in here that would be great.

Thank you!

Clara

[Anonymous · Accepted solution]

Hi @ClaraBcn ,

Please try to use Dynamic format strings for measures. With dynamic format strings for measures, you can determine how measures appear in visuals by conditionally applying a format string with a separate DAX expression.

When using dynamic format strings, the measure keeps its data type and isn't forced to change to a string data type. This applies different format strings to the measure depending on the context.

More details: Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[ClaraBcn]

Thank you! It worked!