How to expand/collapse row in Table visual in Power BI

Question

I have 2 tables - IncidnetLog and IncidentLatest. IncidentLog is the list of logs for each incident , hence it contain multiple rows for same incident, containing duplicate value in Incident ID column. IncidentLatest is the latest and unique detail (latest row based on Modified date) from IncidentLog table.

I have created a report in Table visual in Power BI fetching IncidentLatest records. Now I have requirement to expand/collapse each row in the table visual which will show/hide the respective detail from IncidentLog table.

Is this possible in Table Visual? Or what can be alternate implementation for this?

Answer 1

You can either use a matrix visual. If you put two fields on the rows it will automatically add a +/- button. If not then go to the matrix visual options under Row Headers > +/- Icon an activate it.

You can do this in a table visual as well (right click on the column value and chose Group). But I would recommend a matrix, its way easier to handle.