Forum Discussion
Format a Calculation Group Item
I did this calculation to group the items:
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.
1 Reply
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.