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.  ...
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. 

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

      Hi Matni,

       

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

       

      prateekraina

      • Matni's avatar
        Matni
        New Member
        9 years ago

        Hi, 

         

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