Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix is Grouping Rows - Results Don't Match Tutorial Video

Hello   I've only started trying to learn Power BI recently so this is going to be a very noob question but hopefully one that has a simple answer. I'm watching the video in this link: https://docs...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi Anonymous - the "Date" field on the sales table is stored as text not as a date.

     

    Change it to a date, either in the query (Transform Data) or on the column itself (highlight column in the Fields pane, go to Column Tools, change "Text" to "Date" under Data Type on the far left.

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Community Champion
5 years ago

Hi Anonymous  - check your date/calendar table and how it was created. This behavior will happen if your date table does not contain the dates on your Sales table.

 

Hope this helps,

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi David

     

    Thanks for your prompt response. It isn't 'my' data as such, it's provided by Microsoft as part of the lab I was following so unfortunately I don't know anything about it or how it was created.

     

    Could it have something to do with the fact that the Year column is classed as a number? And not a date? Therefore Power BI cannot associate it with the dates in the Sales table?

     

    I created a copy of the column and changed it from Whole Number to Date but then it turns 1999 into 21/06/1905, which isn't correct either...

     

    • dedelman_clng's avatar
      dedelman_clng
      Community Champion
      5 years ago

      Anonymous - can you share the pbix you are using? Post a link to google drive/dropbox/onedrive, etc.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi David

         

        Please see attached: Link 

         

        Thanks