Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
78 | |
75 | |
58 | |
36 | |
33 |
User | Count |
---|---|
100 | |
62 | |
56 | |
47 | |
41 |