Forum Discussion
How to replace negative values into brackets without "Format" function?
Hi All,
I am facing issue while replacing negative values into brackets. I am using sig fig conversion in my measure that is not working while using this format function on it. Please help.
Hi prakash11440278 ,
I think you might change your Data type to whole number or decimal number as follows, then you could select custom format.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
prakash11440278 You could try the custom format field in the data model view.
Reference: https://radacad.com/custom-format-fields-and-measures-in-power-bi
Regards,
Nandu Krishna
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍
Proud to be a Super User!
Hi nandukrishnavs ,
I have used format function in my expression. Due to that i am not able to select cutom format option.
Hi prakash11440278 ,
I think you might change your Data type to whole number or decimal number as follows, then you could select custom format.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
prakash11440278 , I doubt you can do it without format
https://www.youtube.com/watch?v=dNLuTqg938A
May be you do format here - https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
prakash11440278 Can you share the Measure expression?
Hi prakash11440278 ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Stephen Tao
