Dimension step in Bar Chart

[#1]

Hey guys,

I have a problem with my dimension step in my bar chart. The dimension I use is a MMM - YY dimension and the bars show the cost's of every month. I used in the dimension axis 'Continuous', but my dimension shows only the following months now:

JAN 13          JUL 13          JAN 14          JUL 14

The bar chart should show ever third month of a year. So what I want is:

JAN 13          APR 13          JUL 13          OKT 13          JAN 14          APR 14          JUL 14          OKT 14

If I wider the chart the scale of the dimension adjusts, but that's no option, because I haven't enough space.

Kind regards,

Patrick Klein

[MK_QSL]

Go to presentation tab and deselect the Suppress Zero Values

If this will not solve your problem, better if you upload sample file along with your requirements.

[sunilkumarqv]

Follow the steps

1.Go to chart  Properties

2.Dimesion tab.

3. below you can see supress when value is null check it

Apply and ok

or

make sure you dimension Axis  should uncheck Continuous

You will get what you reqiured

[Gysbert_Wassenaar · Accepted solution]

It sounds like your MMM-YY dimension is a date field. You can try using a static step of 91 (days).

Or you can try creating a new field where each month has a numeric value that increases by one for each next month. Something like dual( date(monthstart(MyDate),'MMM YY'), autonumber(monthstart(MyDate))) as ReportMonthYear. Then use ReportMonthYear as dimension and set the static step value to 3.