Format Negative Numbers in Power Query in ()

[Anonymous]

Hi Expert

is it possible to format - negative number in Power Query with Brackets..... The number is my tables when the file is uploaded from Excel convert from (1.0) to -1.0 in Power BI. 

[jdbuchanan71 · Accepted solution]

I don't know if you can do it in power query but if you go into the model view and select the column you can set custom formatting there.

This formatting string

#,#.#;(#,#.#);0

Gives me this format in the table.