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.
Hello everyone,
I have one Amount column and it brings me all the numbers to the reports, the problem is that the numbers come in minus 500 instead of (500).
I know this is a common problem but in all the solutions I didn't find anything to fix it .
Solved! Go to Solution.
Great, then we are halfway to the answer 🙂
It probably doesn't work because you are putting a column in the place of a Measure.
I think you should make a measure as Total Amount = SUM(Amount), and then use that measure in this Formating.
Measure = FORMAT(Total Amount,"#,###0;(#,###0)")
or you can make this all in one measure with a variable :
Measure =
var Total Amount = SUM(Amount)
return FORMAT(Total Amount,"#,###0;(#,###0)")
Hi,
I'm not completely sure about the question. If I understand you correctly you
want to format the Amount, if it is negative to put Amount into brackets.
If this is correct just make a measure like this :
You got me right, but it's a solution I've already tried and it doesn't work for me, this is the message I get
Great, then we are halfway to the answer 🙂
It probably doesn't work because you are putting a column in the place of a Measure.
I think you should make a measure as Total Amount = SUM(Amount), and then use that measure in this Formating.
Measure = FORMAT(Total Amount,"#,###0;(#,###0)")
or you can make this all in one measure with a variable :
Measure =
var Total Amount = SUM(Amount)
return FORMAT(Total Amount,"#,###0;(#,###0)")
Many thanks for the time and greatly appreciate it
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 |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |