How to make a two columns table in a vizualisation pane

[Anonymous]

Hello,

I have matrix containing many records.  However, with the help of slicers / filters, it is possible to reduce the volume of information presented into the matrix.  Then as the first column contain the employeeID, a unique field into the matrix, I would like to make a drill trhough a hide tab. 

In this tab, I would like to present a table for only one employee in the following form.

Field Name                    Value

Employee ID:                123456

Employee Last Name:   Black

Employee First Name:  Joe

Office Location:            Quebec City

....                                   .....

The value is associated to field Name show on the left column that we already have in various tables.  This two columns table will contains many fields but for only one employee at the time because a drillthrough is done on employee ID, a unique value.

So the question is how can we make or built this two columns table or matrix?

Thanks in adavance for your assistance.

alepage

[v-chuncz-msft · Accepted solution]

@Anonymous ,

In the Format section of the Visualizations pane, you may enter "Show on rows" in the "Search" textbox.