Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
matout
Helper I
Helper I

Balance sheet number formatting

Hello,

 

I have a tablet that show the balance sheet of a company, where revenue and expenses are shown, to calculate profit or loss.

 

The client needs this specific requirments of having all the expenses shown as numbers between brackets (###,###.##)

 

Any idea how I can achieve this.

I tried having a calculating column where I can enter the type of the item in the balance sheet (expense or revenue).

But I am stuck of having the conditional formatting works as a condition of different column.

 

Please help

1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @matout 

 

Try this measure:

 

Expences between brackets =
FORMAT ( MAX ( 'Table'[expenses ] ), "($#,##0)" )

 

Output:

VahidDM_1-1630399781600.png

 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your Kudos VahidDM_0-1630399745819.png !!

View solution in original post

1 REPLY 1
VahidDM
Super User
Super User

Hi @matout 

 

Try this measure:

 

Expences between brackets =
FORMAT ( MAX ( 'Table'[expenses ] ), "($#,##0)" )

 

Output:

VahidDM_1-1630399781600.png

 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your Kudos VahidDM_0-1630399745819.png !!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors