custom scale in line chart

[Workener]

Hi guys,

I configured a milestone s-chart with a time line. It is based on a line chart. The x-axis displays the months. I can change the start and finish month, but I can't find the option to optimize the scale. It always displays the scale on a two-month basis, but I need to include each month. Is this possible? Can you help me?

Thanks!

JB 

[v-chuncz-msft]

@Workener,

You may select the Type Categorical and use a slicer if necessary.

[Workener]

@v-chuncz-msft , I tried this already. If I choose categorical, I do only see months with actual data. The values are calculated, so there‘s no option to select „Show values without data“. Unfortunatly, this didn‘t work for me.

[v-chuncz-msft · Accepted solution]

@Workener,

You need to drag the date from a calendar table.