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,
I have a column that is called "project". its format is decimal number. I want to show negative values with brackets. I tried to make a measure (Measure=FORMAT([Project];"##,###;(##,###);-")
The PowerBI highlights under Project as if it doesn't recognize it. What should I do?
Best,
Solved! Go to Solution.
@IF ,
What is [Project] exactly? Is it Measure or just a fields or Calculated column?
If it is field from table so try to use aggreagation like SUM,MAX etc.
@IF ,
Use the below DAX:
So you have to turn your column PROJECT into a measure. There are too many values, so you need to use MAX/MIN/SUM/etc. to tell the measure what specific value to turn into that format.
You will need two measures, for example:
Measure1 = MAX(Table[Project])
Measure2 = FORMAT( [Measure1], "###,###; (###,###); -")
(make sure to use more # if your numbers go into the millions i.e. "#,###,###; (#,###,###); -"
Hi,
Thanks it works, but the total gives wrong sum. How can I display correct sum?
Best regards,
Refer the below video:
Or you can also try using Dax:
= IF([Project]<0,&"("& [Project]&")", [Project])
Hi,
When I type [Project], the power bi doesn't recognize it. it underlines it with red unfortunatelly.
@IF ,
What is [Project] exactly? Is it Measure or just a fields or Calculated column?
If it is field from table so try to use aggreagation like SUM,MAX etc.
@IF ,
Use the below DAX:
Hi,
Thank you very much for the help. it helps. The last issue if you could help: when I put brackets, I don't want to see the minus sign. it should be for example; -3 or (3) However, the sum should be as you showed. For example; (3)+4 sum:1 Is there any possibility not to show the minus value?
Regards,
IF
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 |
---|---|
98 | |
96 | |
78 | |
72 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |