Can we merge row in matrix visual

[Santho_BI]

Hi All,

Can we achive the below in Power bi table

Input

Expected Output

[Santho_BI]

Thanks @andhiii079845 it's working. can we achieve like this in table visual

[andhiii079845]

I think you have to use the matrix.

[andhiii079845 · Accepted solution]

Yes use a matrix "Name" and "ID" in the rows. Values column in the value.

Make a drilldown and modify the settings of the matrix:

I make a little workthrough yesterday: https://community.powerbi.com/t5/Desktop/Creating-a-Matrix-with-a-static-column/m-p/3114741#M1055248