Forum Discussion

Matni's avatar
Matni
New Member
9 years ago

How to force Power Bi to show data as uploaded

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

6 Replies

  • prateekraina's avatar
    prateekraina
    Icon for Memorable Member rankMemorable Member
    9 years ago

    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's avatar
      Matni
      New Member
      9 years ago

      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.