Forum Discussion
Need Help with Dynamic Grouping Please.
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
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.
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 PabbuThank you both for your reply. I am disappointed that Power Bi doesn't support this. 😞 Thanks for the best solution!