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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
juanjohn
Regular Visitor

PowerBI visualize a large timeline with a non uniform X axis

I have a dataset that has values recorded over the past 4 years. I can visualize it by plotting it the normal way where the X-axis is very long when I group values based on the week. (Roughly 4*52). However so much granularity is not required for the older data. Can I instead have a visualization such that in the current month bucket size is one week. For values older than 4 weeks and earlier than a quater each month is the bucket. Further older than the current quarter, bucket size elarges to a year. 

 

Is such a functionality achievable by viaualization or settings? Or something similar? 

2 REPLIES 2
Phil_Seamark
Microsoft Employee
Microsoft Employee

Probably not so much in any currently available visual.  However you can achieve your custom buckets simply by adding a column to your date table which uses DAX to dynamically allocate days to buckets.

 

Bare in mind, if you have a bucket with more days, any measure based on SUM will be larger in your visual.  Perhaps you could switch to AVERAGE to get a better trend line?

 

Let me know if this sounds interesting and I'll knock something up.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

The solution you mentioned using custom buckets using DAX is also a uniform X-axis right? I wanted a differnetial sizing of buckets over time. I guess, I will use fourth different timeline graphs with different bucket sizes 😄 Thanks for the answer Phil. 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.