Data Label with Parenthesis

[Anonymous]

Hi All,

I'm working for a Finance dashboard. I have a KPI which default values always negative.

I have to show it with Parenthesis.

As an example

My KPI Default               Needed Style
-1.598.241                           (1.598.241) 

I don't want to convert it to text because i couldn't use it in most of charts with text.

Is there any option to do this ? 

Thanks all 

[v-piga-msft]

Hi @Anonymous ,

Are all the KPI values negative? It they are, you could create a calcualted column or custom column like below.

column= 'Table1'[kpi]* -1

If your KPI values are both negative and positive numbers, you could create the calculated column with IF function.

Column = IF('Table1'[kpi]<0,'Table1'[kpi]*-1,'Table1'[kpi])

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[Anonymous]

You completely didn't understand what i want. I don't want to change the values sign to negative or positive. I just want to show negative values with Parenthesis.

As an example from excel, there is an option in home page to format cell behavior. I need something like that

 

[v-piga-msft]

Hi @Anonymous ,

Sorry for my misunderstood.

I'm afraid that there is no similar options in power bi as that in excel.

You could try the calculated column with the formula below.

Column =
IF (
    'Table1'[Data] < 0,
    "(" & 'Table1'[Data] * -1 & ")",
    FORMAT ( 'Table1'[Data], 'Table1'[Data] )
)

Here is the output.

Best  Regards,

Cherry

[Anonymous]

as i understand you were changed the Data Type to Text. I'm unable to use text data type because of making mathematical operations.

Is it possible to do that with with decimal number or whole number data types ?

[v-piga-msft]

Hi @Anonymous ,

Sorry for the delay.

By my tests, I'm afraid that the data lable with "()" will be identified as text type in Power BI Dekstop.

May be you could use the whole number type column make mathematical operations and use text type to show in the visual?

Best  Regards,

Cherry

[Anonymous]

+ i can't use it in any grapichal visual expect matrix table or score card.