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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
sd_kevin
Advocate II
Advocate II

How to align positive and negative numbers on the decimal when using parenthesis

Hi,

 

Is there a way to set a number format to align positive and negative numbers on the decimal when using parenthesis for negative numbers (similar to Excel custom number formatting, _(* #,##0.0_);_(* (#,##0.0);_(* "-"?_);_(@_))? I tried using the same custom formatting in Power BI but did not have the same/expected result.

Power BIPower BITrying to get this (similar to Excel)Trying to get this (similar to Excel)

3 REPLIES 3
mjdemenis
New Member

Hi,

 

In Power BI the underscore "_" does not work to leave a blank space after the number. However, you can format "#,##0.0 ;(#,##0.0); #,##0.0"  and put it so as not to wrap the text.


Note that for positives and zeros there are spaces after the value.


If you use a monospaced font it's perfect.

Dynamic Format - decimal aligned.png

 

I hope I was helpful.


Marcos José Demenis
linkedin/in/MarcosJoseDemenis

v-luwang-msft
Community Support
Community Support

HI  @sd_kevin ,


Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

v-luwang-msft
Community Support
Community Support

Hi @sd_kevin ,

I suspect this cannot be amended. I have searched and have not found any mention of this, and also have the same problem in Tablix, where the numeric format you have chosen will never align if you have negative values because you are I have also tried in Power BI and have not found any changes.

 

 

Best Regards

Lucien

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

Top Kudoed Authors