Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
sayali_deshmukh
Helper III
Helper III

Stacked column chart- Date axis showing date with time values

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.

Capture2.PNG

 

4 REPLIES 4
Anonymous
Not applicable

@sayali_deshmukh 

Change the axis type to Categorical.

 

x aixs type.JPG

 

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.

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

amitchandak
Super User
Super User

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.