Category is appearing twice on graph

[ryanBI]

Hey,

I'm having an issue with my report and not sure what is going wrong.

On my report, I've got categories that are appearing more than once even though they are the same. I've included a screenshot below of what I mean.

It's providing seperate values for them too and not sure why. For example, maintenance appears twice as seperate categories on a graph with seperate values even though it is the same category. I've checked the data and there isn't any space or mispelling to cause this so not sure why.

Any help is appreciated!

[LookingforIt]

PowerBI is rubbish for viewing data - even the table view was not giving the true data. 
I ended up going into Excel, and investigating there - I found some cells had an extra space, "Good" vs "Good " which was creating the extra colmn. 

[serpiva64]

Hi,

can you post some data? 

[ryanBI]

Sorry, can't post actual data, but here's a screenshot from excel. As you can see in Excel, there is only one category for maintenance. But this same column on PowerBI is showing Maintenance twice.