Forum Discussion

cwindsor's avatar
cwindsor
Regular Visitor
6 months ago
Solved

User Input for Custom Grouping

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 ...
Need Help
Tips and Tricks
  • v-dineshya's avatar
    v-dineshya
    6 months ago

    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

     

     

v-dineshya's avatar
v-dineshya
Community Support
6 months ago

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

 

 

  • v-dineshya's avatar
    v-dineshya
    Community Support
    6 months ago

    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

    • v-dineshya's avatar
      v-dineshya
      Community Support
      6 months ago

      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