X-axis configuration 'Line and stacked column chart'

[Anonymous]

Hello,

Is there a possibility to turn this (current)...

X-axis with all values displayed

...into this (design), so basically hiding the labels on the x-axis for every quarter and only showing the hours:

X-axis with only hours, but all columns

[v-sihou-msft]

@Anonymous

In this scenario, you need to aggregate your data on hour level to get your expected chart. You should add a column for hours in your source table. Then just drag this hour column on X-axis.

Regards,

[Anonymous]

Hello Simon,

I don't think that's quite true. I tried that, but then it summarizes four columns of each 15 minutes of an hour into one column for an hour. But that's not what I want.

What I want is, to still show the four columns for each 15 minutes of an hour, but only have the full hour notation (23:00, 00:00, 01:00 etc.) shown on the x-axis, exactly as it is in the design (the second picture).

Do you see my predicament now? Is it possible you think?

Regards,

Robin

[tringuyenminh92]

Hi @Anonymous,

It is possible, but you have show only in duration 2 hours or less, it will be automatically scale out 15 or 10 or 5 ^_^ Basically, we could not control that duration 😞 

check with duration 115 minutesauto scale based on data but wrong expectation