Forum Discussion

Danielwood's avatar
Danielwood
Helper I
1 year ago

Table visual to combine data

Hi. I have a table which has purposely duplicate data, but with a different reference. Is there a way to display the data where the duplicate part is merged into one?

 

the table would be like this

 

Nameref
SolutionAbc1
Solution Def2

 

The duplicate data would be displayed first, so is there a way for PBI to essentially merge that? Or any other ideas on how to display this?

Need Help

2 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    1 year ago

    Hello Danielwood ,

     

    you should use the matrix visual and format it as in the screenshot and drill down so it would look like this

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, Danielwood 

     

    Have you solved your problem? If not, please let us know what output you expect.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.