Reply
Highlighted
Regular Visitor
Posts: 22
Registered: ‎08-09-2018
Accepted Solution

Negative values to be displayed prepend with brackets

Hi there,

    We have certain problem in converting the minus (-) sign into Brackets ' (  ) 'sign for the numerical values on the Matrix visual. There is a solution for string values, but what we have is numerical value. 

 

We used the following expression to conver the minus to bracket,

 

Measure = FORMAT(-100,"$#,##0;($#,##0)")

 

But, the above expression gave the result in string value; which has to be a numeric value since it is an amount field.

Please verify the attached screenshot that depicts the way we want to have the values with brackets. your esteemed help is much appreciated. 

 

bracket.JPG

 

Thanks,

Praveen. 


Accepted Solutions
Super Contributor
Posts: 659
Registered: ‎07-25-2018

Re: Negative values to be displayed prepend with brackets

Hi @praveenkumarv

 

The measure seems correct. It's not supported to change the measure from string values to numerical values.

1.png

 

Regards,

Cherie

View solution in original post


All Replies
Super Contributor
Posts: 659
Registered: ‎07-25-2018

Re: Negative values to be displayed prepend with brackets

Hi @praveenkumarv

 

The measure seems correct. It's not supported to change the measure from string values to numerical values.

1.png

 

Regards,

Cherie

Regular Visitor
Posts: 22
Registered: ‎08-09-2018

Re: Negative values to be displayed prepend with brackets

[ Edited ]

Hi Cherie,

     Thank you very much for your reply to my question. I understood that it is not possible to convert the values with brackets to numerical values in Power BI. 

 

 

Thanks & Regards,

Praveen.