Veritcal reference line

[jduenyas]

Hello gurus

I needed a vertical reference line in my chart which is based on month/year dimension.

Before applying the vertical reference line the chart looked like so:

In order to get the vertical reference line I had to change the Dimension Axis to Continuous. But that changed the displayed values of the dimension and added a semi monthly grid. Here it is:

How can I format the Dimension to show MonthName (month and year as above) which is not in the Number formatting tab and how can I get rid of the "mid month" grid?

Thanks

Josh

[jduenyas]

Sounded logical but it does not work. My dimension is of the format MMM YYYY to begin with and does not contain any other dates except for the Month and Year.

Thanks though

[stabben23]

Hi,

can you give us the Expression in the chart and a tableview of the model.

[Peter_Cammaert]

The mid-month labels are a result of converting your X-axis to a Continuous type. The axis itself will contain all integer values between each first-of-the-month day, whether you want it or not, whether your series contains other data points aside from the first of the month values or not.

What you are asking for is a Continuous axis that displays discreet values (just the first of the month) which leads to an infight in the display engine

AFAIK there is no works-in-all-cases solution to this. The best thing you can do is tweak the graph and X-axis so that it shows at most one label for every month, like Marco seems to have managed in his example. As soon as the content or scaling of the graph changes however, you may be in trouble again. Sorry.

Peter

[MarcoWedel]

Hi,

if you can't use continuous x-axis then maybe you could use some other mean to mark specific dates (here one example for a bar chart instead of a line chart):

Re: In a chart - can I show "today"?

hope this helps

regards

Marco