The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
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.
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!
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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
101 | |
82 | |
62 | |
55 |
User | Count |
---|---|
252 | |
119 | |
115 | |
95 | |
70 |