Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
What is the best way to format a measure to show the negative numbers in paranthesis, negative 100 is (100).
This is my model.
Thank You,
Michael
Solved! Go to Solution.
@mikebi please use this, it will do the job.
Formatted Sales = IF([Total Sales] < 0, "(" & FORMAT(ABS([Total Sales]), "#,##0.00") & ")", FORMAT([Total Sales], "#,##0.00"))
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
@mikebi So, Dynamic format strings for measures are a preview feature that you have to turn on. Once you turn them on you can go here and choose Dynamic and paste in the format string I provided.
The problem with doing it using FORMAT is that you turn the number into text and that is often a very bad thing if you are trying to plot the number in a line graph for example. But, if you are just displaying it in a table or matrix then it might not be so bad.
@mikebi Use this as your custom format string:
#,0.###############;(#,0.###############);#,0.###############
Hello,
Where can I define the Custom Format String in Power BI?
Thank You,
Michael
@mikebi So, Dynamic format strings for measures are a preview feature that you have to turn on. Once you turn them on you can go here and choose Dynamic and paste in the format string I provided.
The problem with doing it using FORMAT is that you turn the number into text and that is often a very bad thing if you are trying to plot the number in a line graph for example. But, if you are just displaying it in a table or matrix then it might not be so bad.
@mikebi please use this, it will do the job.
Formatted Sales = IF([Total Sales] < 0, "(" & FORMAT(ABS([Total Sales]), "#,##0.00") & ")", FORMAT([Total Sales], "#,##0.00"))
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
143 | |
111 | |
108 | |
99 | |
95 |