Required Month and year in x-Axix

[Anonymous]

Dear All,

I have result based on my input. But my client wants to have Month and year in bottom.
Being beginer I am struggling to get this.

Can any on please help me how can I get this.

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Just takimh an example as follows. Create a chart with the DATE column on x-axis and your metric under values section, then you will get the following: (You will see a complete date hierarchy shown)

Now suppose, if you just want Month & Year on the x-axis, for that just remove the Quarter and Day part from the DATE hierarchy and then drill-down to the lowest hierarchy on the chart; you will get the following:

Thanks,

Pragati