Year and Month Axis in Charts

[Anonymous]

Hi all ,

i have a dimension Year & '-' & Month used in the axis of a bar chart.

its displayed as shown below ..  

now i dont want to show years repetitively.. instead have one common label 2016 under those months which belong to 2016.

like wise for all years.

Kinldy help

Thanks

[sudhirpkuwar]

Why dont you use MonthYear as Dim

It will show like this

Jan-16,Feb-16,Mar-16.... and so on

which is better than showing the whole Year and Month

[maxgro]

this chart has 2 dimensions, year and month and 2 expression, the second expression is invisible

[Anonymous]

Hi Massimo,

Thanks for your reply , this works , but there are empty months coming up even when there is no data.

I tried checking Suppress null values option , but it doesn't work.

kindly suggest on what can be done in this situation.

Thanks

[sudhirpkuwar]

Make sure "Show All Values" is deselected in the Dimension tab

[Anonymous]

Hi Sudhir ,

The "Show All Values" is deselected in the Dimension tab , but seems like it doesn't work.

Have you tried ?

Thanks