topic Re: How Create Graph with Date difference and age bucket in DAX Commands and Tips

How Create Graph with Date difference and age bucket

nish18_1990 — Thu, 03 Apr 2025 13:01:59 GMT

Hi,

I have data like below :

Logic for Age is : Created date -Today date

Bucket is based on age : if it is <30 days then "<30", if <60 and >31 days then "<60 "

I need to show in graphs like below :

Please attache Power BI file for reference .

Thanks

Re: How Create Graph with Date difference and age bucket

lbendlin — Thu, 03 Apr 2025 14:10:32 GMT

Please make an effort to provide sample data in usable format, not as a screenshot.

Re: How Create Graph with Date difference and age bucket

johnt75 — Thu, 03 Apr 2025 14:30:55 GMT

You can use the techniques described in https://www.daxpatterns.com/static-segmentation/

Re: How Create Graph with Date difference and age bucket

nish18_1990 — Fri, 04 Apr 2025 05:04:55 GMT

Category	Quantity Q2	country	Created date
Tables	20	China	23/05/2025
Cars	30	China	21/01/2025
Bikes	40	China	21/03/2025
Chairs	13	India	21/01/2025
Tables	22	India	21/02/2025
Cars	54	India	21/01/2025
Bikes	60	India	30/01/2025

Re: How Create Graph with Date difference and age bucket

nish18_1990 — Fri, 04 Apr 2025 05:05:13 GMT

please find the attached table

Re: How Create Graph with Date difference and age bucket

v-sgandrathi — Fri, 04 Apr 2025 06:49:41 GMT

Hi nish18_1990,

Thank you for using Microsoft Community Forum.

Below is the approach to achieving your desired bar chart visualization in Power BI based on your sample data.

Open Power BI Desktop, go to Home > Get Data, choose Excel or CSV, select your file, and click Load to import the data.

To calculate age, create a new column in Power BI using this DAX formula:

Age = DATEDIFF(TODAY(), 'Sheet1'[Created date], DAY)

This will give the number of days between today and the created date.

To group records by age range, create a new column using this DAX formula:

Bucket =

IF('Sheet1'[Age] < 30, "<30",

IF('Sheet1'[Age] <= 60, "<60",

IF('Sheet1'[Age] <= 90, ">30 - 60",

">60"

)

This will categorize each record into buckets like <30, <60, >30 - 60, and >60 based on the age in days.

To create the bar chart, go to the Report View in Power BI and select the Clustered Column Chart from the Visualizations pane. Drag Created date to the X-axis, Sum of Quantity Q2 to the Y-axis, and Bucket to the Legend. Then, format the chart by sorting it by Created Date, adjusting the colors for each bucket, and renaming the chart to "Sum of Quantity Q2 by Created Date and Age Bucket.

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

Thank you.

Re: How Create Graph with Date difference and age bucket

v-sgandrathi — Thu, 10 Apr 2025 04:44:30 GMT

Hi nish18_1990,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.