topic Re: Help in formatting in Developer

Help in formatting

09avinash — Tue, 13 Jun 2023 03:03:43 GMT

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

Re: Help in formatting

Anonymous — Thu, 15 Jun 2023 06:16:12 GMT

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

Re: Help in formatting

09avinash — Thu, 15 Jun 2023 06:50:54 GMT

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