Date format without horizontal scroll bar

[mohammadrafic]

Hi team, please i need the date format without horizontal scroll bar like below if date gaps between the values no prob. how can i achive.

[Icey]

Hi @mohammadrafic ,

Change the X axis type from Categorical to Continuous if your x axis column is date or date/time type.

Doesn't "mmm yyyy" meet your requirements?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mohammadrafic , You need to give more space to visual. Or restrict values.

Other options are , Do some changes  in under x-axis

1. Inner Padding 

2. Max Category Width

3. MAx Size 

[mohammadrafic]

@amitchandak tried but no hope. i dont have space to increase the visual. i need exactly like below chart. 

[amitchandak]

@mohammadrafic , use date convert to the continuous axis and try

[mohammadrafic]

there is no option as you mentioned because date data type is converted to text.

Month = FORMAT('ESP Request'[REQUEST_START],"MMM-yy")

[amitchandak]

@mohammadrafic , Not with text, You have to use the date. it should automatically should convert yo month year  based on data

[mohammadrafic]

i know but i need to use as "MMM-yy" format always.