- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
format negative numbers in paranthesis from a measure
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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 !!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@mikebi Use this as your custom format string:
#,0.###############;(#,0.###############);#,0.###############
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Where can I define the Custom Format String in Power BI?
Thank You,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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 !!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-26-2023 12:31 AM | |||
07-09-2024 02:59 AM | |||
Anonymous
| 05-10-2024 02:11 AM | ||
09-18-2024 01:17 AM | |||
10-19-2020 09:35 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |