Add more tick lines to x and y axis

[pgomez58]

Good morning,

Is there a way to add more ticks on the x and y axes for a regular line/column chart in Power BI? Here is an example of a chart: is it possible to customize to add every 1 or 2 year intervals in the x-axis?

[v-agajavelly]

Hi @pgomez58 ,

I hope the response provided helped in resolving the issue. If you still have any questions, please let us know we are happy to address.

Regards,
Akhil.

[v-agajavelly · Accepted solution]

Hi @pgomez58 ,

Circling back were you able to get the X-axis looking the way you wanted after switching to Continuous and adjusting the Min/Max? If it’s still not lining up as expected, let me know and we can try the custom date column option or explore a visual that gives more granular control.

Regards,
Akhil.

[Shahid12523]

- X-axis (years): Set axis type to Categorical to show every year or use a custom year table.
- Y-axis: Manually set Minimum, Maximum, and Interval in the Format pane.
- Dual axis: Format each y-axis separately.

[v-agajavelly]

Hi @pgomez58 ,

Just wanted to check did switching the X-axis to Continuous and tweaking the Min/Max get you closer to the tick spacing you had in mind? If not, we can try the custom date column route or even look at a lightweight custom visual to give you exact control.

Regards,
Akhil.

[v-agajavelly]

Hi @pgomez58 ,

In Power BI’s default line or column charts there isn’t an option to manually set “tick every 1 or 2 years” like in Excel, but you can get close with this practical tweak.

1. Go to Format pane → X-axis.
2. Change Type to Continuous (instead of Categorical).
3. Scroll down in the X-axis settings and set Minimum and Maximum dates so the chart covers exactly the range you want.
4. Power BI will then auto-space the ticks more evenly. If you still want fewer or more ticks, create a custom column in your date table that only labels the years you want to show, and use that as the axis instead.
5. For the Y-axis, turn on Minor gridlines (Format pane → Y-axis → Gridlines → Minor gridlines = On) to add extra ticks between the main ones.

That’s as close as you can get without moving to a custom visual like Charticulator or Deneb, which allow you to hard-code tick spacing.

Regards,
Akhil.

[Greg_Deckler]

@pgomez58 You can add x constant lines if the x-axis is numeric or a date.