The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I did this calculation to group the items:
Solved! Go to 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.
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.
User | Count |
---|---|
65 | |
62 | |
59 | |
53 | |
28 |
User | Count |
---|---|
181 | |
82 | |
67 | |
47 | |
44 |