Forum Discussion

Whats_A_PBI's avatar
Whats_A_PBI
Frequent Visitor
6 years ago
Solved

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?

 

https://brocksolutionsinc-my.sharepoint.com/:u:/g/personal/molmstead_brocksolutions_com/ESnroDJNiANMtKkpMlvkni8BFBf0f1n-vtJuc0mcE-SlAw?e=XfGbD2

4 Replies