Dynamic Bins Size by Parameter

Hi fahadqadir ,

depends which parameter you want to use.

DAX doesn't support dynamic calculate columns. Theoreticaly you could open your model in Tabular editor and find your group. Since calculated group is just a DAX code, you might find something which looks like this (my Groups for Age):

I can set up, that the values 5 (which determines size of my group) is taken from a measure / slicer, but then the group (calculated column) stops working.

Instead you can use M query parameter. This solution is not that user friendly, but you can create calculated column in Power Query. Disadvantage is, that your table needs to be reloaded every single time you change the parameter. So in case you deal with milions of rows, its not really convenient.

In case you would like to try the Power Query approach, let me know.