How is month and year displayed at the same time in hierarchy?

[ignas]

Hey
I came across this report. I cannot understand how it was it possible in the graph to display month and year at the same time like in the picture?

Here you can get the file: Link

Thanks in advance.

Ignas

[v-yuezhe-msft · Accepted solution]

@ignas,

When you use the third button  to drill down  the visual, you can get year and month displayed at the same time.

When you use the second button as shown below to drill down the chart, you will only get Month level.

Regards,
Lydia

[Anonymous]

Hello@ignas 

It's simple, you only had to put on the axis option the date hierarchy and the visual automatically create the option, if you want you can do it a level of days. A workaround for this is create a new column "Month-Year"

Test this on the file.