Logical Date order of Visuals

[Anonymous]

Hi,

I am trying to get a logical date order for a visual when presenting 2017 and 2018 data. Currently, the visual is showing January, February, March, April etc however I want it to display the year as well becuase at the moment it is technically incorporating January 2017 and 2018's data just in 'January:

The field tools display Year and Month (as a date hierachy) but it is not appearing. My data model is also set to (MMMM/yyyy).

As a note this data is being pulled from google analytics  - would this play a role in the issue?

Thanks

[v-piga-msft · Accepted solution]

Hi @Anonymous,

I have made a test with the data connected with Google Analytics, everything works as expected.

Please check if you have clicked the Drill down?

You could try to Drill down and then you will get the expected result.

In addition, you could refer to my test pbix file.

Best Regards,

Cherry