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

lbendlin's avatar
lbendlin
Super User
1 year ago

This is not dynamic grouping (which isn't supported by Power BI anyway) - these are three separate measures that frankly should not be shown like this (repeating the same data in a visual is a design red flag).