cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

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

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.

3 REPLIES 3
Community Support

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())``

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.

New Member

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

Super User

@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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.