X axis labels are cut off when adding a column series

[PaulusD]

Hi all,

Got a "challange" with a line and stacked column chart.

I have line values which go throughout 2020 (for the current period).

I have a running total for YTD figures in the column values, this works fine so far:

correct axis

The x axis labels are cut short when adding a column series.

cut short axis

X axis is based on a seperate date table marked as such.

Without the column series, the x axis runs thourgh 2020, with the column series the x axis is cut short at feb 2020 (current month)

Any tips on this?

Thanks!

[v-lid-msft · Accepted solution]

Hi @PaulusD ,

We can try to use the following measure as the column value to meet your requriment:

Column Value Measure = CALCULATE(SUM('Table'[ColumnValue]))+0

Best regards,

[PaulusD]

Thanks @v-lid-msft , let me try this when I get a spare moment and let you know if it works :).

[v-lid-msft]

Hi @PaulusD ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,