Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
09avinash
Frequent Visitor

Help in formatting

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 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

vyiruanmsft_0-1686809503047.png

How to Display Negative Numbers Between Parentheses in Power BI - BI Gorilla

vyiruanmsft_1-1686809758794.png

Best Regards

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

vyiruanmsft_0-1686809503047.png

How to Display Negative Numbers Between Parentheses in Power BI - BI Gorilla

vyiruanmsft_1-1686809758794.png

Best Regards

Spoiler
Hi i try with given format
Negative value is showing in bracket and decimal point also showing upto 1 but value is showing in thousands not in million
I want value also in million

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.