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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Correcting negative values in the graph?

I have a graph showing indicator values that are in the billions home and when I came up some value less than 1 billion the value is negative, changed the type of data to thousands had improved but some values still appear negative, I believe it is something simple to fix but I'm not finding the option for it

 

Untitled.png

2 ACCEPTED SOLUTIONS

@Anonymous What is the column that displays the negative number? Is that a measure? There is obviously something that is converting your numeric values to a negative...

You can filter the data out, but I'd look at why it is converting all positive numbers to a negative rather than removing something from your dataset. I can't read the language, so I don't know what to specifically detail.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

@Seth_C_Bauer I agree with you

 

And I kind of tried to tell him the same thing - but he brushed it off - so I just showed him how to hide it

 

That negative data that shows up - it doesn't just appear out of thin air

 

I would look into it but he claims there's no negative data so I just left it at that...

View solution in original post

7 REPLIES 7
JhonatanSalvado
New Member

I have the same problem. I tried to filter the results, but don't work. I don't have negative numbers in my table. 
I used ABS to change negative to positive number. 

JhonatanSalvado_0-1720449941614.png

 

JhonatanSalvado_1-1720450028901.png

Also, the filter show the negative numbers. 

JhonatanSalvado_2-1720450106673.png

The table came from .CSV 

Sean
Community Champion
Community Champion

If you want to hide the negative values - use a Filter.

 

But it looks like (and I have no idea what I'm looking at) but it looks like you have Negative Values in the data you aggregate

 

So I don't know what you mean correct the negative? Unless you go and change the numbers in your data source...

 

 

Anonymous
Not applicable

I have no negative data in my database.

and how I could make this filter negative values?

@Anonymous What is the column that displays the negative number? Is that a measure? There is obviously something that is converting your numeric values to a negative...

You can filter the data out, but I'd look at why it is converting all positive numbers to a negative rather than removing something from your dataset. I can't read the language, so I don't know what to specifically detail.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

I have created a new colum with ABS to transform all negative to positive numbers. But in the grath keeps showing negative numbers in the day 30. 

JhonatanSalvado_0-1720450626792.pngJhonatanSalvado_1-1720450692433.png

 

@Seth_C_Bauer I agree with you

 

And I kind of tried to tell him the same thing - but he brushed it off - so I just showed him how to hide it

 

That negative data that shows up - it doesn't just appear out of thin air

 

I would look into it but he claims there's no negative data so I just left it at that...

Sean
Community Champion
Community Champion

Look in the Visual Level Filter => click the Measure(All) on the Measure that gives the Negative Value

 

Select => is greater than => Enter 0 => click Apply Filter

 

Filter 1.png

 

That's it!

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors