Stacked column chart- Date axis showing date with time values

[sayali_deshmukh]

Hi,

I have a Stacked column chart with Date on X-axis. While selecting a single months date-time values show on X-axis. Does notm happen if multiple months selected. The data table contains entries against date.
Screenshot attached.

[V-pazhen-msft]

@sayali_deshmukh 

Change the axis type to Categorical.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sayali_deshmukh]

Hi @V-pazhen-msft 
Setting axis type to Categorical results in a scroll bar in case of longer time line on X-axis.

[amitchandak]

@sayali_deshmukh , Your data might contain the timestamp of datatype might be DateTime. Change it to Date and instead of  date Hierarchy use  Date

[sayali_deshmukh]

Hi @amitchandak 
The data is in Date format.
Not used the Date Hierarchy in graph.