https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-dynamic-Peer-Groups/m-p/2971608#M99343 <P>I'm looking for direction on how I can create dynamic peer groups.&nbsp; 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.&nbsp; The user could then see how their selected peer group compares to the rest of the respondents in each of the visuals.&nbsp; 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.&nbsp;</P><P><img /></P><P><BR />It has to be dynamic, meaning a user can change a demension of the peer group at will.&nbsp; Can anyone direct me to an article, video, etc. that might give some direction on how to create?</P> Thu, 15 Dec 2022 18:30:45 GMT MEnewbe 2022-12-15T18:30:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-dynamic-Peer-Groups/m-p/2971608#M99343 <P>I'm looking for direction on how I can create dynamic peer groups.&nbsp; 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.&nbsp; The user could then see how their selected peer group compares to the rest of the respondents in each of the visuals.&nbsp; 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.&nbsp;</P><P><img /></P><P><BR />It has to be dynamic, meaning a user can change a demension of the peer group at will.&nbsp; Can anyone direct me to an article, video, etc. that might give some direction on how to create?</P> Thu, 15 Dec 2022 18:30:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-dynamic-Peer-Groups/m-p/2971608#M99343 MEnewbe 2022-12-15T18:30:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-dynamic-Peer-Groups/m-p/2971881#M99366 <P>I think you're looking for field parameters:&nbsp;<A href="https://www.sqlbi.com/articles/fields-parameters-in-power-bi/" target="_blank">https://www.sqlbi.com/articles/fields-parameters-in-power-bi/</A></P> Thu, 15 Dec 2022 21:56:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-dynamic-Peer-Groups/m-p/2971881#M99366 vicky_ 2022-12-15T21:56:20Z