Expand a row into details

[haymanezzeldin]

Good morning,

Is it possible to have a table that contains a sum, and by clicking on the row then it expands down to show the details of this sum?

I have this table in Power BI:

The row shows the employees, the total work done, and the number of activities done.

I would like to click on any of the users for example, to get the details of these values, something like this:

 

But without the repetition of the name, and expand just for the user clicked

Thank you.

[v-sihou-msft]

@haymanezzeldin

Currently it's not supported to drill through to details associated to selected entry only. You can only have the detail information appeared in another table visual and have this table cascading filtered when an user selected. You may submit a feature request on idea.

Regards,

[Anonymous]

Has this issue been resolved?  Are we now able to expand one row at a time into details? How about creating a measures hierarchy to expand one row at a time into details?  @haymanezzeldin 

[vanessafvg]

You can do a drill down in the new matrix - but I'm not sure it will do exactly what you want?  Are you wanting only one to be expanded at a time?

There are 2 matrices in power bi, if you havent enabled the second one you can do so in your file , settings , preview features

this will allow you to drill down into detail, One line at a time or alternatively you can expand all rows with the details

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/

[haymanezzeldin]

Dear @vanessafvg,

Thank you so much for your response, in fact I did think about Matrices, it fixes part, but still it doesn't allow me to show just one record, rather it shows everything.

Do you think this is doable?

Regards

[vanessafvg]

i have the exact same issue at the moment, and have not been able to find a solution, so dont think so.  But maybe (and that would be great( if i was wrong)