cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Frequent Visitor

## Formatting of negative values

I have a value of -8000, and divide by 1,000,000, so equal to -0.008. It would not show as -ve value if decimal place = 1.

Would you have any tips on formatting to show negative value in 1 d.p. such as -0.0 / (0.0)?

P1. if D.P = 1, it would show 0.0

P2. if D.P = 2, the –ve sign would show expected

P3. If D.P = 3, if we set D.P. = 3, the –ve sign would show expected

2 REPLIES 2
New Contributor

## Re: Formatting of negative values

well there's no such thing as -0 in math - so we aren't going to find a solution via that route is my guess  .....  I think it must be creative trick-eration....

perhaps establish  "neg" word/text that is dependent on the true value - and get creative in including that in the visual.....

www.CahabaData.com
Moderator

## Re: Formatting of negative values

Hi @howardng,

It's expected that the value display in 0.0 when set decimal place as 1, as the -0.0 doesn't have any meaning in math. You can see when you type the data -0.0 via Enter Data, it will change to the 0.0 automatically. I don't think display -0.0 make sense, the results you get are correctly.

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

## Helpful resources

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 83 members 1,172 guests
Recent signins:
Please welcome our newest community members: