Need help with line chart x-axis

[parvathisuku_90]

Line chart x-axis is skipping the values,

ie, missing december , feb etc..Can some one please help.

[Greg_Deckler]

@parvathisuku_90 You need to change from Continuous to Categorical in your x-axis.

[parvathisuku_90]

If I change x-axis to categorical then it is showing every date. But I need not show only months.

[v-diye-msft · Accepted solution]

Hi @parvathisuku_90 

1. You can add the calculated column = month(table(date))

Then put it to the x-axis and set the type as continuous.

2. You can create a calendar table and manage the relationship with fact table, then use the date as xaxis

[dedelman_clng]

Hi @parvathisuku_90 - that is the known and expected behavior of the X axis on line charts. You may want to consider removing gridlines from the X-axis, if the "missing" months are going to be too distracting to your users.

David

[dedelman_clng]

Hi @parvathisuku_90 - 

This behavior is because your X-axis is set to "Continuous", not "Categorical". You can switch it to categorical, but then every date entry gets its own spot on the axis and it may introduce a scroll bar as the data extends out to the right.

Hope this helps

David

[amitchandak]

@parvathisuku_90 , When axis type is continuous, line visual skips months. The other option is categorical