Format a Calculation Group Item

[Syndicate_Admin]

Source Community: Power BI | Source Author Name: rpinxt

I did this calculation to group the items:

[v-binbinyu-msft · Accepted solution]

Hi @Syndicate_Admin ,

To format a Calculation Group Item, you can utilize the Dynamic format string feature. This allows you to specify a DAX expression to create a format string, which can dynamically change the format of your calculation item based on its context. Here's a step-by-step guide:

1. Navigate to the Calculation Item: In Power BI Desktop, go to the Model view and locate your calculation group. Then, select the calculation item you wish to format.

2. Enable Dynamic Format String: In the Properties pane, find the Dynamic format string option and turn it on.

3. Specify the Format String: Enter a DAX expression that returns the format string you want to apply. For example, to display a percentage, you might use a simple format string like "#,##0.00%".

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.