CODEWITHSUNDEEP
chartspowerbivisualizationpowerbi-desktop
user21068571
user21068571

Reputation: 23

Power BI - x axis skips year

The chart has data from 2009 to 2023. The tooltip shows value from 2009 to 2023. But the label in the x-axis shows only the even number years (2010 to 2022).

I do not prefer changing the x axis to categorical as it will show all the data from 2009 to 2023 and it will have a scroll bar.

When I enlarge the visual, it shows 2024, but not 2023. It has data till 2023. The tooltip also shows the data but the axis is not showing the year.

So far I have tried the following:

  1. reducing the font size.
  2. changing the maximum value in x axis.
  3. enlarging the visual.

However, the issue is not solved.

Upvotes: 0

Views: 1888

Answers (2)

davidebacci
davidebacci

Reputation: 30174

All the options available to you with native visuals have been tried. If you choose continuous, then PBI will decide what labels to show. If you use categorical, then you'll see every label.

If you want finer control over ticks and axis labels, you need to use a non-native visual. I can recommend Deneb which will give you the level of control you seek.

Upvotes: 5

user21068888
user21068888

Reputation: 11

Try to make the font size small and i hope it works.

Upvotes: 1

Related Questions