Custom formatting for totals, or using a metric for totals.

[Chillytouch]

Hi,

So I'm a little bit on the newer side with power bi development, and I had a user make a request of a field in a matrix. It's a pretty simple matrix, and there is a field that is basically debits and credits sums. The credits show as a positive number and the debits show as a negative number, and then the power bi automated total shows the correct amount. The problem is that the user does not want the debits to show the negative paranthesis signs. They want to see them as regular positive numbers, which is easy enough to do with custom formatting. However, they still want the total to show up with parenthesis if it's negative because that's a negative location overall. 

Is there any way to do this? After searching around I've found no way to do this because you can't custom format the total separate from the column values. 

I've attached 2 screen shots. The one on the left is how it looks now. The one on the right is how the user wants it formatted.

 

[v-luwang-msft · Accepted solution]

Hi @Chillytouch ，

Base data:

Then create the below measure:

Measure = IF(HASONEVALUE('Table'[Type]),ABS(MAX('Table'[value])),format(SUM('Table'[value]), "#,###  ; (#,###)"))

Output result:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[amitchandak]

@Chillytouch , you can use isinscope or isfiltered and you can change measure formatting, but that can make it a text datatype