Show values in a matrix based on a person name.

[mibshara]

I am new to Power BI and trying to get a matrix to show information based on a column value, and have all other columns seperated vertically for every row in the first column.

Here is more details:

Table_A have three columns.      Person_Name | Question | Answer

Row 1:                                         John | How old are you? | 25

Row 2:                                         Nicole | How old are you? | 28

The way I would like my dashboard to show it is as follows:

John

----

Question | Answer

How old are you? | 25

Nicole

----

Question | Answer

How old are you? | 28

Any ideas?

[v-haibl-msft]

@mibshara

We can create an almost same Matrix with following steps. For details, you can refer to the attached PBIX file.

1. Create a measure using following DAX formula.

Measure = 
IF ( ISFILTERED ( Table1[Question] ), CALCULATE ( MAX ( Table1[Answer] ) ) )

2. Drag Personal_Name, Question into Matrix Rows, Measure into Matrix Values. Rename Personal_Name and Measure in Fields.

Click Expand all down one level in the hierarchy in the top left corner.

Best Regards,
Herbert