How to force Power Bi to show data as uploaded

[Matni]

Good morning, 

I'm having some trouble with a graph I'm trying to make showing sales data. The data I have is from September 2016 to August 2017 and that's how I've built it on my Excel sheet. 

However, whenever I upload the data and create a simple line graph, Power Bi changes the month order to be January - December. I've been pulling my hair out trying all kinds of different ideas on how to force it to stick to my data but it always reverts to the same layout. 

Any help would be greatly appreciated. 

G

[prateekraina]

Hi @Matni,

In order to understand the scenario and help you could you please tell us what are the columns in the table and what is the data type of them when you pull them into Power BI desktop from Excel.

Kindly share some screenshots if possible.

Prateek Raina

[Matni]

Hi Prateek, 

Thanks for the reply. 

The data is in 3 columns, 

• A = Month [September 2017 - August 2017]
• B = Units Sold [whole number]
• C = Units Refunded [whole number]

This is how the graph is coming out as standard. 

The green line is the sales [B] and the grey line is the refunds [C]. I'm happy with all of it, I just need it to start in September and finish in August rather than January to December. 

[prateekraina]

Hi @Matni,

I am mostly interested in the data type of your Month column.

@prateekraina

[Matni]

Hi, 

It's set as the first of each month [Please note I'm in the UK and we do DAY|MONTH|YEAR

[prateekraina]

Hi @Matni,

I agree with @CahabaData.

@prateekraina

[CahabaData]

check in PBI that the Purchase Month field is indeed modeled as a Date/Time field rather than a Text field.,,,,if text, of course you should change it to Date.....