Increase Data Invervals and dynamic dotted line in front of the last bar of a graph chart

[Spyrosmak]

Hello everyone,

I have some sales data on the y axis and the current interval is 2. Meaning that data goes from 0 to 8 with a pace of 2. 
Does anyone know if I can customise this pace 1,2,3 etc. I have tried to start from a minimum range of 2,3 etc but it doesn't work as I would like it to. Since I want the pace to be 3 and range gives me random interval.

Secondly I would like to know if I can add a dynamic dotted line in the below chart like this. Meaning that since the graph will have updated data, I would like to know if I can put a line like this before the last bar. The goal is to differentiate the last bar from the others.

Thank you in advance if you can help me with this.

[Anonymous]

Hi, @Spyrosmak 

Regarding the first question, maybe you can modify the Range setting in the Y-axis settings and turn on the Logarithmetic scale.

Regarding the dynamic dashed line, we can find the Reference Line in format, click to create a new line, and then put the created measure into Value

Here is my preview:

The measures you create are shown below. My measures and data are just an example and are just for reference.

DottedLine = IF(MAX('Table'[Date]) = TODAY(), MAX('Table'[Sales]), BLANK())

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Spyrosmak]

Hello and Thank you for your recommendation. The first interval solution doesn't work for the reduction of the data points that I want to achieve. The second solution in my case creates a horizontal line and not a vertical one. I have dates in the x axis. 
Thank you

[amitchandak]

@Spyrosmak , for month year, I doubt you can have that line. But if you use date, means continuous axis. You can use constant lines on X-Axis too. And you can use a measure on that