Forum Discussion

RDansereau's avatar
RDansereau
Frequent Visitor
1 year ago
Solved

Need Help with Dynamic Grouping Please.

Hi, Trying to dynamically create 1 visual that shows groups based on slicer selection-no hard coding. Data is not imported(if that matters). I have tried multiple ways, but cannot seem to get a sol...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi RDansereau,

     

    Power BI does not support truly dynamic grouping in the way you can dynamically segment in tools like R or Python. What you’re aiming for — grouping data into multiple levels based purely on slicer input — cannot be natively modeled in a single visual using dynamic group definitions.

    The solution shared by lbendlin is currently the most practical workaround.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


    Regards,
    Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi RDansereau,

 

Power BI does not support truly dynamic grouping in the way you can dynamically segment in tools like R or Python. What you’re aiming for — grouping data into multiple levels based purely on slicer input — cannot be natively modeled in a single visual using dynamic group definitions.

The solution shared by lbendlin is currently the most practical workaround.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


Regards,
Vinay Pabbu

RDansereau's avatar
RDansereau
Frequent Visitor
1 year ago

Thank you both for your reply. I am disappointed that Power Bi doesn't support this. 😞 Thanks for the best solution!