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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi David

 

Thanks, that fixed it! I assumed the problem was with the Date table rather than the Sales table so thanks for that.

 

I received an error though but I think that's more to do with locale issues - I think the data may be in US format and I'm in the UK but it seems to have sorted itself out:

 

DataFormat.Error: We couldn't parse the input provided as a Date value.

Details:

    1/15/1999