Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |