Dynamic time interval grouping/binning from user input

[Whats_A_PBI]

Hi Everyone,

I'm trying to replicate binning on a chart but I'm trying to drive it from user input. Bin groupings can do exactly what I want but it's inconvenient to alter. I've attached a pbix that gives the idea of what I'm trying to do but basically I want the user to be able to choose if the grouping is by day, week, month, etc and the bin size (not the number of bins). With a manually created bin grouping this is really simple: you set the bin size and the time interval. Drill downs are also similar but don't provider any binning.

Is it possible to simulate this dynamically via user input instead?

https://brocksolutionsinc-my.sharepoint.com/:u:/g/personal/molmstead_brocksolutions_com/ESnroDJNiANM...

[Fowmy · Accepted solution]

@Whats_A_PBI 

Hope these links will give you some ideas

https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-count-of-b...
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...

[Whats_A_PBI]

Thanks, I had come across the first link but not the followup.

[Soumyajit41]

Hi can you please share the pbix file here

[Fowmy]

@Whats_A_PBI 

You are welcome!

Don't forget to give KUDOS 👍 to replies that help answer your questions