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