Bins not working only for some data?

[sy898661]

Hello all!

I am back again with a question that is actually making me pull my hair out in frustration. Can someone help me figure out what is going on?! I feel as though I had a similar issue to this recently but it ended up just working out. This, is not.

Here is a snip of my column for PEG Dates in 2019:

Very clearly we see that there are dates in Jan, April, and June.

Here is when I put this column into a visual:

Very clearly 3 items. So far so good.

SO WHY, WHEN I ADD AN AXIS, DOES IT DO THIS?!>?!?!?! 

The axis is Month bins. Very clearly they are Jan, April, and June when I look at the data inthe query. Where the heck is SEPTEMBER coming from?!?!?!!?

There are 5 total products that I have done this EXACT same thing for, and those all work. WHY is this one not working?!

Does anyone have a clue? I'm dying here trying to understand.

[sy898661 · Accepted solution]

ah.... its all in the relationships.

my apologies for rage-posting instead of trying harder to figure it out.