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

       

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

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