Is there any visulaization to expand details in the table visualization?

[Hussain]

Hi,

I want to achieve a functionality in which a user can click on the row and he/she can see the details of that row. Screenshots are attached.

Note: User clicks on the dropdown button(highlighted in red and the column details are seen in the next screenshot).

User can click the drop down arrow in each rowUser is able to see the details.

Is there any way to achieve this or is this too ambitious? I aware of the drilldown functionality. But was wondering if this is possible,

[Tahreem24]

Hi Hussain, 

You can try Matrix visuals and add multiple fields at row header and make the icon available from row header property. You when the user clicks on plus icon sign it will give more drilling details just like excel.

[Tahreem24]

Refer the below link to get the complete deets on it.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[Hussain]

Thanks. But isn't matrix used for aggregations and therefore by default use numbers (values)?

I have text and date data.

[v-kelly-msft]

Hi @Hussain ，

See below blog that may help:

https://www.dundas.com/support/learning/documentation/analyze-data/expand-and-collapse-hierarchy-mem...

Best Regards,
Kelly

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