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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
mhoole
New Member

Chart Axis Intervals

Capture.PNG

Is there a way I can change to labels of a chart (stacked area) to be more granular? I have a chart that has a rolling 24 hour dataset which is in 5 minute intervals. If I set the x axis as categorical it shows every entry label which is way too much, where as if I set it to continuous it only shows a few labels ie 21:00 then 03:00 the 09:00 then 15:00. I would like it to show each hour ideally.

1 REPLY 1
v-sihou-msft
Microsoft Employee
Microsoft Employee

@mhoole

 

Currently, there's no setting to fix the interval on chart X axis. You may vote these ideas: 

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17297545-add-the-axis-interval-in...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15293673-axis-with-configurable-u...

 

For "continuous", when you increase the width of your chart, the granularity on X axis can be lower. 

For "categorical", you may adjust the "Minumum category width". 

 

4.PNG

 

Regards,

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.