Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Dynamic time interval grouping/binning from user input

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?


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


You are welcome!

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors