Histogram

[o59393]

hi all

I have 1400 rows containing a department time in days. I would like to have a histogram that divides in groups of 30 days. (0 to 1 months, 1 to 2 months) etc.

Once it reaches 8 months, it should be grouped by 8 or more months.

I used the histogram of power bi but is very slow and very limited as the data gets bigger.

Here is the excel

https://www.mediafire.com/file/5p469p2vhufikql/report1576508921493.xlsx/file

Column J contains the department time.

Thanks all!

[dax]

Hi o59393,

If you want to set month which >8  as a group, you could try to achieve this by add a column like below by M code

= Table.AddColumn(#"Changed Type", "Custom", each if Date.Month([Process Termination])>8 or [Process Termination] =null then ">8" else Date.Month([Process Termination]))

Then use this in chart axis.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[o59393]

hi dax

Is there a way to create a dax formula without using M code? It's ok if it without the >8, it can be in groups by 30 days.

Thanks!

[dax]

Hi o59393,

I am not clear about your requirement, did you want to create a column which like below?

Column = ROUND(report1576508921493[Department Time]/30,0)

If not, please correct me and inform me your expected output, then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[o59393]

Sorry for not being clear.

I created the histogram in excel witht the department times. As you see there grouped in 30 days. This is what I would like to have in power bi. But instead of showing 30 to 60 days, to show 1 to 2 months, 2 to 3 months, etc.

I appreaciate your help, let me know if it is clear.