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

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'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 ?