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

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?

Solution 1:^[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.

Solution 2:^[2]

This is because you chose the Table visual and the Table visual just has values. If you choose the Matrix visual, you will have rows and columns. The Matrix visual is one to the right from the visual you have selected in your screenshot.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Strawberryshrub
Solution 2	Keramuddin Hussaini

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

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]