Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
Solved! Go to Solution.
@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.
@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...
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.
Also, the filter show the negative numbers.
The table came from .CSV
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...
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.
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.
@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...
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
That's it!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.