Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi @member
I want to format my measure with in million and decimal point up to 1 point and negative value should be with in bracket at the same time.anyone have a solution
Solved! Go to Solution.
Hi @09avinash ,
You can use custom format strings in Power BI Desktop to customize how fields appear in visuals and make sure your reports look just the way you want them to. To display negative values between parentheses, you can use a custom format string. For example, you can use the format string "#,##0.0;(#,##0.0)" to represent 100 million as 100.0 and -100 million as (100.0).
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
How to Display Negative Numbers Between Parentheses in Power BI - BI Gorilla
Best Regards
Hi @09avinash ,
You can use custom format strings in Power BI Desktop to customize how fields appear in visuals and make sure your reports look just the way you want them to. To display negative values between parentheses, you can use a custom format string. For example, you can use the format string "#,##0.0;(#,##0.0)" to represent 100 million as 100.0 and -100 million as (100.0).
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
How to Display Negative Numbers Between Parentheses in Power BI - BI Gorilla
Best Regards
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 10 | |
| 10 | |
| 4 | |
| 3 | |
| 3 |