Forum Discussion
Anonymous
5 years agoNot applicable
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...
- 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
5 years agoCommunity Champion
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