Forum Discussion
Format parameters in Feld parameter
Hello,
I have a Field Parameter in a slicer with 2 selections: (1) percentage children and (2) total children in several zones of a city. When I format the percentage to 1 decimal, the total is changed with 1 decimal også. I want to show the percentage children with 1 decimal and total children with null decimal. How can I do it?
Thank you!
Good question — this is a common limitation when using field parameters.
What’s happening is that the format setting is being applied at the visual level, so both selections (percentage and total) end up inheriting the same formatting.
To handle this, you’ll want to control the format at the measure level instead of relying on the visual.
One approach that works well is to create a dynamic measure using SWITCH() and apply formatting inside it using FORMAT() based on the selected parameter.
For example, something along the lines of:
If percentage is selected → format with 1 decimal + %
If total is selected → format with no decimalsJust keep in mind that using FORMAT() will convert the result to text, so it’s best used when display is the priority (like in labels), not when you need the values for further calculations.
Alternatively, if you want to keep the values numeric, you could separate the measures and control formatting individually, then use the field parameter just for switching between them.
On top of your Parameters, build a Measure:
and Format the Measure with Dynamic:
4 Replies
Good question — this is a common limitation when using field parameters.
What’s happening is that the format setting is being applied at the visual level, so both selections (percentage and total) end up inheriting the same formatting.
To handle this, you’ll want to control the format at the measure level instead of relying on the visual.
One approach that works well is to create a dynamic measure using SWITCH() and apply formatting inside it using FORMAT() based on the selected parameter.
For example, something along the lines of:
If percentage is selected → format with 1 decimal + %
If total is selected → format with no decimalsJust keep in mind that using FORMAT() will convert the result to text, so it’s best used when display is the priority (like in labels), not when you need the values for further calculations.
Alternatively, if you want to keep the values numeric, you could separate the measures and control formatting individually, then use the field parameter just for switching between them.
On top of your Parameters, build a Measure:
and Format the Measure with Dynamic:
Hi HaiVN,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to MasonMA & donbuser for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hello HaiVN,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
