topic Re: User Input for Custom Grouping in Developer

User Input for Custom Grouping

cwindsor — Thu, 19 Feb 2026 16:04:34 GMT

Awhile back, I got frustrated with the limited grouping options for histograms, so I created some calculated columns for some default grouping options (see picture).

I am now trying to modify my report to ask the user what grouping they prefer, by having them input a min, max, and increment. I want to use the input to create the column and thus a histogram. Any way to do this?

Re: User Input for Custom Grouping

v-dineshya — Fri, 20 Feb 2026 12:12:45 GMT

Hi @cwindsor ,

Thank you for reaching out to the Microsoft Community Forum.

You cannot dynamically create a calculated column in Power BI based on inputs like min, max, increment.

Calculated columns are computed at data refresh time, while slicers / user inputs work at query time. By using measure + disconnected parameter table you can get the desired result.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Re: User Input for Custom Grouping

v-dineshya — Mon, 23 Feb 2026 13:22:17 GMT

Hi @cwindsor ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

Re: User Input for Custom Grouping

v-dineshya — Thu, 26 Feb 2026 14:50:05 GMT

Hi @cwindsor ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh