title: Getting powerbi to function like powerpivot does
body: <p>I am trying to get a chart in powerbi to function like when I had previously built a chart in powerpivot. </p>
  
  <p>Where it IS similar is that when I have a date field that is in "dd/mm/yyyy" format and I drag that into my chart it auto-converts/expresses the date into a year, month and day field individually. What I can then do however in PowerPivot that I can't seem to figure out in bi is the ability to then drag the year and month separately to the axis section and thus the axis shows all months grouped into the years. BI seems to want to only show the months and the data is grouped year by year or just by the year itself. </p>