Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MEnewbe
Regular Visitor

Creating dynamic Peer Groups

I'm looking for direction on how I can create dynamic peer groups.  Basically what I'm trying to do is have the ability for a user to select a peer group (based on size, region, industry) and have that Peer Group populate in the report visuals.  The user could then see how their selected peer group compares to the rest of the respondents in each of the visuals.  For example, in a bar graph the x axis would have a bar for All Responses, a bar for Peer Group, a bar for Filtered Company. 

MEnewbe_0-1671129025416.png


It has to be dynamic, meaning a user can change a demension of the peer group at will.  Can anyone direct me to an article, video, etc. that might give some direction on how to create?

1 REPLY 1
vicky_
Super User
Super User

I think you're looking for field parameters: https://www.sqlbi.com/articles/fields-parameters-in-power-bi/

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors