Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data Label with Parenthesis

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 Styl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
v-piga-msft
Resident Rockstar
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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 ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      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