topic Need Help with Dynamic Grouping Please. in Developer

Need Help with Dynamic Grouping Please.

RDansereau — Mon, 05 May 2025 21:31:02 GMT

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.

Re: Need Help with Dynamic Grouping Please.

lbendlin — Mon, 05 May 2025 22:45:31 GMT

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

Re: Need Help with Dynamic Grouping Please.

RDansereau — Tue, 06 May 2025 00:49:53 GMT

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.

Re: Need Help with Dynamic Grouping Please.

Anonymous — Thu, 08 May 2025 04:12:30 GMT

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

Re: Need Help with Dynamic Grouping Please.

RDansereau — Thu, 08 May 2025 11:29:57 GMT

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