Need Help with Dynamic Grouping Please.

[RDansereau]

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 solution to work. Thank you in advance.
Group 1 is avg of selected group

Group 2 is avg of the selected group's category

Group 3 is avg of all.
 

[RDansereau]

Not sure what you mean. This is test data scenario. There is no data repeated unneccessarily.
We need to show the rating comparisons of accounts in 3 groups. Rating of the Account, Rating of all accounts within the same industry of the selected account & lastly all accounts for all industries.

[Anonymous · Accepted solution]

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]

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

[lbendlin]

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).