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, 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!

 

 

Need Help
Show and Tell

4 Replies

  • 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.