Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago

Histogram

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,...
Need Help
Show and Tell
dax's avatar
dax
Community Support
6 years ago

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's avatar
o59393
Post Prodigy
6 years ago

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's avatar
    dax
    Community Support
    6 years ago

    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's avatar
      o59393
      Post Prodigy
      6 years ago

      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.