Composing comparison groups based on different categorical columns

[Anonymous]

Hi everyone,

I have a dataset from a survey, consisting of a unique rows (representing respondents who have answered a series of questions).

The following columns are in the dataset:

• Respondent ID (unique)
• Business Unit (categorical)
• Level (categorical)
• Gender (categorical)
• Columns for each question with an answer from 1 to 9

I transposed the data to be able to calculate avg, stdev etc for each of the questions, and make visuals for each of the categories.

So far so good.

But now I want to take it one step further:

I want to build a comparison visual, where I would like users of the dashboard to be able to choose which "groups" they want to compare, but from different categories (BU, Gender, Level).

E.g., compare the average scores for all questions between Business Unit = X (=group 1), and Gender = Male (=group 2).

It would be even better if people could "compose" their comparison groups from all of the categories.

E.g., compare the average score for all questions between BU=X-Gender=Male-Level=Manager and BU=X (so in essence compare a subgroup with the BU total), or any of the combinations.

Any insights on how to do this would be much appreciated !

Thanks in advance 🙂

Dieter from Brussels

[v-cgao-msft · Accepted solution]

Hi @Anonymous ,

It is possible to change the interactive behavior of the slicer so that it interacts only with the relevant visuals.

Change how visuals interact in a report - Power BI | Microsoft Docs

Please check the PBIX file:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data