Forum Discussion
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 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.
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
4 Replies
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).
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!
