how to do drillthrough and show the dataset in a verical view(Unpivot)?

[Yonas]

I have a dataset like this in the main page

Name    Age  Gender

Jhon      18     Male

Alice      22     Female

Jonas     21     Male

I want to create a drillthrough page on Name column and show the details in a table visual in a vertical manner. for example If i drillthrough on 'Jhon' from the main page, my drillthrough page should look like this

Name      Jhon

Age         18

Gender    Male

Any ideas?

[v-kelly-msft · Accepted solution]

Hi @Yonas ，

1.Go to query editor>Select column"name">Add column >"Duplicate column";

2,Right click on the table name in queries>select "Duplicate";

3.Select column "Age","Gender","Name-copy",then choose"unpivot Columns":

Then create a relationship between the 2 tables as below:

Finally you will see the drillthrough page like:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Yonas]

Thank you!! But I got some problems when i drillthrough to the page, I am getting different sort by on my data, for example

if i drillthrough on Jhon, I get like this

Attribute   Value

Name        Jhon

Age           23         

Gender     Male

If i drillthrough on Alice, I get this

Attribute   Value

Age           22

Name       Alice                 

Gender     Female

How can i fix the variation on sort, I tried the default on the table visual but it would not work?

[VasTg]

@Yonas 

There is an idea.. Please vote it.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32967241-vertical-column-headers-in-matrix

But I found something that might work for you. Create a matrix visual with all the columns under "Rows".

Under Row headers.

1. Turn off +/- icons

2. Set "Stepped layout indentation" to 0.

Make the page as drillthrough for Name and disable "Keep all filters" if necessary.

If it helps, mark it as a solution

Kudos are nice too.