Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |