08-21-2018 01:01 AM
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.
Solved! Go to Solution.
08-21-2018 11:49 PM - edited 08-22-2018 03:26 AM
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,